How can I center data in tables and queries?

[Guest]

Its not really a problem but I would like to center data in colums, because
Access aligns some fields on the left and others on the right.

Ian

 

[Nikos Yannacopoulos]

Ian,

You can't. The reason is tables and queries are not meant for the
presentation of data! Tables are storage containers, queries are
retrieval/update tools. Access uses forms and reports for the
presentation of data, in which you can do quite a lot with the format.

HTH,
Nikos

 

[Larry Daugherty]

Hi,

On your Forms and Reports you can control the alignment of text in all
of the controls by clicking the appropriate icon on the Formatting
toolbar.

HTH

 

[Guest]

Hi Ian-

Just a further note on the points made in other posts as to rationale for
the alignment being as it is...

When working with the datasheet view of a table or query it gives you visual
feedback as to the data type of the field. If the content is aligned rt, it
has been defined as a value data type (such as Number, Date/Time, Currency),
whereas if it is flush left it is Text or something other than a value.

The fact that it is set that way by default & can't be changed prevents the
user from having to switch to Design View to be sure that Zip Codes haven't
been defined as Numbers, etc.

HTH |:>)