centering data within a field

J

jlwood44

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
 
M

MacDermott

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.
 
J

John Vinson

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
Click to expand...

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]
 
Top