Text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Moore - 27 Feb 2004 10:41 GMT

Is it possible to change the alignment of text/numbers in
a table? the reason that i ask is someone i know (not me,
honest!)has designed a data base table and the text is
right aligned!

Thanks in advance

Michael

Reply to this Message

Cheryl Fischer - 27 Feb 2004 16:51 GMT

Yes, Michael, it can be done by putting an Asterisk and a space in the
Format property of a Text type field in the table's design view. Access
will then change this to **.

IMO, this is one of those things that could be classified as a "cheap
trick". As this format is "sticky" and propagates to Forms and Reports,
you will spend a lot of time re-setting the alignment back to Left or
General.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

> Is it possible to change the alignment of text/numbers in
> a table? the reason that i ask is someone i know (not me,
[quoted text clipped - 4 lines]
>
> Michael

Reply to this Message

Thanks - 28 Feb 2004 09:19 GMT

Thanks for that, it was a great help. Just out of
interest, is it possible to centre align text?

Thanks

Reply to this Message

Cheryl Fischer - 28 Feb 2004 14:15 GMT

Not that I know of. All formatting should be done on forms and reports.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

> Thanks for that, it was a great help. Just out of
> interest, is it possible to centre align text?
>
> Thanks

Reply to this Message