Good day,
Can anyone show, if possible, how to change the font setting on query sheet in the design view. While the data is displayed?
Good day,
Can anyone show, if possible, how to change the font setting on query sheet in the design view. While the data is displayed?
It's under fileŽoptionsŽDatasheet from the main tool bar.
You can set font type and size.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
When queries are updatable they are basically copies of tables (or at least portions of tables) and the general consensus is that you shouldn't be working in tables. So wanting to change the font suggests that you're giving access to tables through queries. That might be OK if it's just you because as the developer one can assume you know the risks. Not a good idea in general though.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thanks for your help Minty. However the font options are Size and Weight. There is no type option, so it could not work.
Hi Micron. Yes I am the only one with access to the table. However, my problem is that on my new computer the font in the query sheet are different than elsewhere in the program, and it is veery difficult to read. That's why I wish it could be changed.
See if File>Options>Object Designers>Query Design is what you need. There are font and size options there, but I believe it will affect all of your queries if that's ok.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba