Misbehaving Column

[rogertrigg]

I've got a table one field in which displays justified left. Queries based on this table invariably display this field justified right. Nothing I've tried will change this naughtyness. The table was originaly imported from Excel.

[JoeM]

What does the Table show as the Data Type for this field?
What does the data in this field look like (can you post a few examples)?
In your Query, are you displaying this field outright, or doing a calculation on it and showing that (if the later, please post the calculation)?
Of what importance does the justification play in the query?

[rogertrigg]

The data type is short text, 255 chars. It's a simply list of roads. In the query all records (about 300) are shown. The order of fields from report from the query is important.
I'd like to post the grid view but it defaults to 'auto fit' destroying the evidence.

[JoeM]

You should be able to justify the field, as you need, on the Report.
Queries, themselves, are really just used to return data, and a lot of those formatting features don't really work on them.
You typically have the formatted results appear in Forms and Reports.

[rogertrigg]

You got it, Joe. I clicked the 'Road' field in Report 'Design View' to bring up its Property Sheet on which there's 'Text Align' property giving the option I needed. Should have spotted myself to save the trouble I've stirred up.