how set font in make table query

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

Guest

Thanks for any help.
I have a make table query, and I would like it each time to make it in the
Courier font, so that digits line up. But it makes it in some other font, and
I have to select all and change it each time I re run the query. Which seems
pretty often. Is there a way to set the font for a make table query?
Thanks!
 
Hello Ian.

Ian said:
Thanks for any help.
I have a make table query, and I would like it each time to make it
in the Courier font, so that digits line up. But it makes it in some
other font, and I have to select all and change it each time I re run
the query. Which seems pretty often. Is there a way to set the font
for a make table query?
Thanks!
Click to expand...

A Table is a database object that can contain data, and a make table
query also is a database object that essentially consists of a select
into statement.
Neither a table nor a make table query have a font property. The font
that is used by access to display the data in the datasheet can be
changed in datasheet view, or you can change the dafault font for
datasheets using tools/options.
 
Thanks Wolfgang!


Wolfgang Kais said:
Hello Ian.



A Table is a database object that can contain data, and a make table
query also is a database object that essentially consists of a select
into statement.
Neither a table nor a make table query have a font property. The font
that is used by access to display the data in the datasheet can be
changed in datasheet view, or you can change the dafault font for
datasheets using tools/options.
Click to expand...
 
Thanks for any help.
I have a make table query, and I would like it each time to make it in the
Courier font, so that digits line up. But it makes it in some other font, and
I have to select all and change it each time I re run the query. Which seems
pretty often. Is there a way to set the font for a make table query?
Thanks!
Click to expand...

No.

Don't confuse data STORAGE - which is done in tables - with data PRESENTATION
- best done in forms or reports.

In practice, make-table queries are very rarely either necessary or
appropriate. If you're trying to get a subset of data in a table (or tables)
into a report, it's not necessary to make a new table to do so; just base the
report (with controls formatted with Courier or any font that you like) on a
Query selecting the data. If you're repeatedly importing data, empty a table
and append the imported data into it.

Perhaps you could describe the process and your reason for repeatedly running
make-table queries; I'm sure there's a better way.

John W. Vinson [MVP]
 
Back
Top