CODEWITHSUNDEEP
databasems-accessms-office
Chen Stats Yu
Chen Stats Yu

Reputation: 113

how to make "nicer" Access Forms in 2016?

The file is here.

I am very new to access. Here is what I already have enter image description here

I want to make it nicer, which has the following look: enter image description here

Difficulties are:

1 - The checkbox is too small. Can't make them larger. 2 - Even in the design view, I can't find an easier way to align the cells. 3 - When using the form to input data, can we make the font size bigger?

Many thanks!

Upvotes: 0

Views: 1037

Answers (2)

nicomp
nicomp

Reputation: 4647

You can't make the check box larger but the label associated with the check box is clickable so the user has a bigger target to click on. You can align cells in the form designer by changing the x/y properties of the cells as a group -- select the desired cells, open the properties window, and change the desired properties.

Upvotes: 2

Johnny Bones
Johnny Bones

Reputation: 8404

Anything you can do in Excel, you can do in Access. It's all a matter of skill level and attention to detail. That being said, there are certain limitations.

There is only 1 size for a checkbox. If you want it bigger, you have to create a textbox with some OnClick code behind it. You would then have to have some code to translate this back to Yes/No data. You can probably do something like:

Private Sub MyField_OnClick
  If MyField.Text = "" Then
    MyField.Text = "X"
  Else
    MyField.Text = ""
  End If
End Sub

This will set the field to either "X" (checked) or "" (unchecked). There are probably other ways to do this as well, such as making it an OLE control and swapping out images of a checked and unchecked box, depending on the last active value.

Aligning cells is easy, it's a formatting issue. Select all your controls (which you can do by selecting one control, hold the Ctrl key down and then select additional controls with the key still pressed), right-click and choose Align from the menu. Done.

And yes, you can make the font size anything you want. Just expand the textbox a little to fit the font, go into the textbox's Property window and change the font name, size and/or weight.

Upvotes: 1

Related Questions