centering data within a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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