Access 2002 Table format question

C

Chas

How can I enter data into a cell and select to have the data either fixed to
the left most point of the cell, the center of the cell, or the right.
 
T

tina

if you're talking about entering data directly into a field in a table
("cell" is an Excel term, not Access), AFAIK you can't control column
alignment. by creating a form to enter your data, which is the standard
method of data entry, you can control many formatting properties, including
"left/center/right alignment".

hth
 
J

John Vinson

How can I enter data into a cell and select to have the data either fixed to
the left most point of the cell, the center of the cell, or the right.
Click to expand...

An Access Table *is not a spreadsheet*. They are VERY DIFFERENT.

One of many ways in which they are different is that Tables are
designed for data storage, *not* for data display or presentation. In
fact in a finished application, users should never even *see* tables.

If you want to control the appearance of data onscreen, use a Form
with textboxes (or other controls); a Textbox has a rich range of
format properties including left, center or right justification. If
you want to control how the information is printed, use a Report -
which also lets you do this. Use table datasheets only for design and
debugging.

John W. Vinson[MVP]
 
Top