MS Access 2007 design view

mildbil · 2012-01-06T18:41:15.000Z

Any MS Access design expert out there?

I have a question regarding ‘Check Box’ option when designing a form.

is there a way to have Access show the check box on the screen, but when printing out, only have the ‘Check’ print out, and not the ‘Check Box’ box…?

I’ve tried different combos to see if i can work around it, by putting white borders, transparent, hairlines, ect. but the printout still show the box and the check.

Thanks!

lawriedalman3018 · 2012-01-07T03:48:30.000Z

I think you’ll find they are ‘Check Boxes’ their name alone implies they will print with a box. To get the result you want you might be better of using another field type like Number or Text and assign the field as only a 1 or 0, one being true or 0 being false. Or you could use a boolean field which is either True or False.

gerard-treacy · 2012-01-09T03:48:02.000Z

You can use a normal checkbox on the form and use a different control on the printout to achieve this (assuming you have created a seperate report and are not just printing the form). Change the report control to a textbox and set the source to =iif([my field name]=True,“a”,“”). Set the border to transparent and the font to webdings. This will give you a check mark with no box.

mildbil · 2012-01-09T11:04:58.000Z

Gerard9944

yes, i know it’s a check’Box’. but you know how customers what things done a certain way…

Unfortunately, it is printing out the form.

These are reminder cards that get printed out.

But, I do like your idea of possibly having it printout as a report.

I may need to modify the whole thing.

Thanks for the input!