make table query format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a make table query. I would like to set the font type and size of the
resulting table. I can set the format manually, however evry time I run the
query it resets. I have also tried changing the format of the query using
the datasheet view, however this does not seem to affect the format of the
resulting table. Does this require VBA coding in the query to correctly
fromat the table and, if so, what is it?

Thanks for the help.

P.S. I know this is easily accomplished by using a form, however I really
need the table formated.
 
The short answer is that you should not let people see the tables. Tables
only should be used to hold data. Queries are similar.

Use forms and reports to display data. There you can format to your heart's
content.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run 2nd query using results from 1st query 0
different formats in query & table 1
Database Import Duplicate Issue 0
Add autonumber to a large table? 0
Make Table Query Only Runs After Edit 1
Automatically set the data type as date for a Make Table Query 3
Pass Through Make Table 7
Make Table query will not work but does work in Datasheet view 4

Back
Top