Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 67
  • Last Modified:

Can I align left in an Access table

I have a table that I am using another table as  a look up.  The data in that is aligned right.  I don't like that.  I don't write code.... is there a simple way to make it align left?
0
Ange1ia
Asked:
Ange1ia
  • 3
  • 2
  • 2
  • +2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Open the table in Design view, select your column and then click the Formatting option needed. See the screenshot for more details.
FormatTable.png
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not sure I completely follow .. but if you enter the bang (!) symbol in the Format property of the Field (see image),  that will force Left Align

! Force left alignment instead of right alignment.

mx
Capture1.gif
0
 
donaldmaloneyCommented:
All Table properties are Left aligned.
I don't see any alignment property for a Table.
If i is a form you're looking at you would need to change the properties of each field in the forms ("Design View") to Left Align.
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
donaldmaloneyCommented:
Ange1ia
OK,  I have older MS access version .  What version are you using?
Don
0
 
Ange1iaAuthor Commented:
Access 2003
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Did you happen to try what I posted above ?

mx
0
 
Ange1iaAuthor Commented:
Yes it worked I'm updating this site now in another window.  Perfect!

Thanks so much.

Angie
0
 
EE_AutoDeleterCommented:
I've requested that this question be deleted for the following reason:

                           
No comment has been added to this question in more than 21 days, so it is now classified as abandoned and is now flagged for deletion.


If there is a valid solution, please OBJECT and indicate the comments that are, or would otherwise lead to, a solution.


Use the specific format https:#axxxxxxxx for comment ID(s).


Also, please don't object simply because the author did not respond to your comment. While we understand this is frustrating, unfortunately we cannot force the author to return to the question. Unless you feel you have presented a valid, verifiable solution we'll simply delete the question.


Experts-Exchange Auto Deleter
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Delete request pending /??
Why ??
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now