Text alignment for queries

[Pat Hartman]

I don't actually have a sub-form saved as a form I have the sub-form object with its source object parameter set to the query listing the data.

This was one of the worst decisions ever made by the Access team. It is wrong for users to interact directly with tables and queries and so the interface should not make this easy for people who don't know that it is poor practice. Creating a subform is trivial and the wizards will do it for you.

As had been mentioned several times. Queries should not be displayed for users to interact with so who cares how the data is aligned. Left is the natural alignment for text and dates (which are displayed as strings) and right is the natural alignment for numeric values (technically numbers are aligned at the decimal point.

If you are displaying data, use the formatting options available for controls on forms and reports.

 

[namliam]

How about not responding to a thread originaly from 2009 ! 11 years must be some kind of record?

 

[Pat Hartman]

I wasn't responding to the old thread. I was responding to the the person who revived it. I just quoted something from the original thread which is the heart of the problem.

 

[plog]

... 11 years must be some kind of record?

Not even close:

unsplit database

I used the database splitter to split my database but now I need to do some testing on it and I don't want to use the REAL thing. So I copied the database but I'm still linked to the REAL data. How do I "unsplit" or bring everything back into 1 database? Thanks, Rick

www.access-programmers.co.uk

Started May 2003
Dormant for 10 years until June 2013
Redormant for 5 years until July 2018
Currently dormant for 2+ years....but I'm just biding my time.

 

[namliam]

I wasn't responding to the old thread. I was responding to the the person who revived it. I just quoted something from the original thread which is the heart of the problem.

Wasnt refering to you @Pat Hartman , rather to the person you responded too

 

[Pat Hartman]

I'm easily confused

 

[Sarah.M]

I applied Matt's suggestion (#14) "To left align right aligning text stick "!" in the format properties of the field in query design view".
Also I found out that using "?" aligns text to the right. Does anyone know a similar way to force-align the text to center?
ReinM

"?"
Works Thanks!