make table query format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rwinans - 16 Mar 2007 16:02 GMT

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.

Reply to this Message

Jerry Whittle - 16 Mar 2007 17:37 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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
[quoted text clipped - 7 lines]
> P.S. I know this is easily accomplished by using a form, however I really
> need the table formated.

Reply to this Message