Access 2002 Table format question

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

 

[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

 

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

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]