We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Align Text in an Access Query

Updated March 23, 2017

A Microsoft Access query is the result of a detailed filtering of data in an Access database. The query lists a cross section of information from data tables in your document. To align the text in your Access query results move the information to a standard data table first, which offers you more formatting options.

Loading ...
  1. Click the option to create a new table on your Access toolbar. Double-click the "Add New Field" title and type in the same name as the field containing the query text that you want to align. For instance, if the field name is "Field1" in the Access query, type that exact name as the title of the column in your new table.

  2. Locate the query name in the left-hand panel of Access. If you don't see the query listed by default, click "All Access Objects" at the top of the left-hand panel and check "Queries" from the drop down list.

  3. Click and drag the name of the query over to the new table that you have open. Place the small icon in the exact field where you want the query text to appear. Press "OK" when prompted by Access to append the information.

  4. Select the entire column or row containing the text that you want to align. To select a row or column just click either the field name at the top of the column or the side tab next to each row.

  5. Press the left, centre, or right align button on the Access toolbar to align your query text. Click the "X" in the corner of the open data table and press "Yes" to save the new table.

Loading ...

About the Author

Louise Balle

Louise Balle has been writing Web articles since 2004, covering everything from business promotion to topics on beauty. Her work can be found on various websites. She has a small-business background and experience as a layout and graphics designer for Web and book projects.

Loading ...
Loading ...