How do I center text in a column in the database?

25 Feb 2005 3:39 AM

silvertopfox

I have a database set up and have two columns that will just need an "x" in
them. How do I center the text as the column heading makes it quite wide?

25 Feb 2005 4:21 AM

Scott

You don't center data in a table.

You could however create a Form in Datasheet view and select the field that
you want centered and set the alignment to center for that field. When you
view the form the "X" will be centered.

Depending on what the X in your field was supposed to mean, you could set
that field as a YES/NO field and it would put a check box in the table for
you.

Show quote

"silvertopfox" <silvertop***@discussions.microsoft.com> wrote in message
news:CAB4593E-2880-47B1-8FA3-F65D4156322C@microsoft.com...
> I have a database set up and have two columns that will just need an "x"
in
> them. How do I center the text as the column heading makes it quite wide?

25 Feb 2005 5:10 AM

John Vinson

On Thu, 24 Feb 2005 19:39:03 -0800, silvertopfox
<silvertop***@discussions.microsoft.com> wrote:

>I have a database set up and have two columns that will just need an "x" in
>them. How do I center the text as the column heading makes it quite wide?

Table datasheets are not designed or intended for data presentation,
but for data storage.

Store your data in a Table; to display it onscreen create a Form (in
which you can set column widths at will in a Datasheet, or even better
in a continuous Form); for printing, use a Report.

John W. Vinson[MVP]