centering data within a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jlwood44@hotmail.com - 24 Oct 2005 00:51 GMT

I have a number field next to a text field. The number field is to the left
of the text field. Without rearranging the order of the fields, is there a
way of separating the data so that the fields do not seem as one?
Right now I'm seeing: 10M
when I would rather see: 10 M

Reply to this Message

MacDermott - 24 Oct 2005 01:23 GMT

Sounds as if you're working directly in a table.
In Access, tables are for storing data; forms and reports for displaying it.
Create a form based on the table.

> I have a number field next to a text field. The number field is to the left
> of the text field. Without rearranging the order of the fields, is there a
> way of separating the data so that the fields do not seem as one?
> Right now I'm seeing: 10M
> when I would rather see: 10 M

Reply to this Message

John Vinson - 24 Oct 2005 02:27 GMT

>I have a number field next to a text field. The number field is to the left
>of the text field. Without rearranging the order of the fields, is there a
>way of separating the data so that the fields do not seem as one?
>Right now I'm seeing: 10M
>when I would rather see: 10 M

If you are concerned about how the data looks, use a Form for onscreen
display, and a Report for printing. In the Form or Report, you can
arrange the textboxes however you wish, and align the data in the
textboxes centered, left or right as appropriate. Table datasheets are
of *very* limited capability and aren't designed for display purposes.

John W. Vinson[MVP]

Reply to this Message