Ugly large checkboxes on Access table

AShaw

Registered User.
Local time
Tomorrow, 05:40
Joined
Jul 3, 2014
Messages
23
Hello!

I am not usually an Access user but I have been asked to amend a database. On the form, six checkboxes have been added and when I go to the table these checkboxes appear as large ugly checkboxes that are so enormous that only five records can be viewed on screen at once.

I have attached a screen print.

The user wants the checkboxes to remain on the form, but they want a Yes or No response on the table. Surely I can change these ugly checkboxes to a simple Yes or No in the table? Design View tells me the following information:
Data Type: Yes/No
Format: True/False
Display control (under Lookup): Checkbox.

Thanks for any ideas. :)
 

Attachments

  • DB screen print.jpg
    DB screen print.jpg
    100.1 KB · Views: 628
I don't knw why the checkboxes are so large but users should never directly see the table anyway.

Create a form based on the table and show that to the users instead.
 
Never mind. I tried a few things and changed the Lookup to a Text Box which seems to have produced a better result. Thanks anyway.
 
But those are pretty awful looking. Do you know where the RecordSelectors are? All the way left on a record there is a margin. Hover your mouse over that margin, and lower it to the line between records at the record selector. You should get a drag handle on the mouse pointer, and drag/resize the height of the row. See if that alters the size of the check boxes. Failing that, what is the font size?
 
I don't knw why the checkboxes are so large but users should never directly see the table anyway.

Create a form based on the table and show that to the users instead.

Thanks Galaxiom. I had written my second comment before your response had appeared.
Yes, its bizarre that the checkboxes look so large but I can only assume that the database designer wanted it that way for some reason.
The team wants to be able to analyse their results in the future so they're planning to hire an analyst nearer the time. I wanted to make sure the table results are easy to read for when that employee starts.
 
But those are pretty awful looking. Do you know where the RecordSelectors are? All the way left on a record there is a margin. Hover your mouse over that margin, and lower it to the line between records at the record selector. You should get a drag handle on the mouse pointer, and drag/resize the height of the row. See if that alters the size of the check boxes. Failing that, what is the font size?

Great! Thanks for that.
 
Issue came up once before and I beleive the check boxes will appear huge and ugly if the Display is set to anything above 100%. Use Form View and you should not have a problem.
 

Users who are viewing this thread

Back
Top Bottom