How do I set format for table text field?

[Big Pepper]

Hi,
I would like to set a table text field that character starts on left.
Please help!!
Thank you,
Mimy

 

[S.Clark]

What situation do you have which causes the characters to NOT start on the
left? For example, do you use a Right-to-Left language in your Windows
Regional Settings?

Maybe fully describe what is meant by 'that character starts on left.'

 

[Big Pepper]

my table has a LastName as a text field and I want to sort it. If they enter
a 'space' before a character then the name start with 'space' will show on
the top.
thanks,
Mimy

 

[Linq Adams via AccessMonster.com]

There's nothing you can "set" to do this. Assuming you're trying to do this
sort in a query based on your table, create a calculated field to remove the
space

TrimmedLastName: Trim([LastName])

Now sort on the calculated field, TrimmedLastName.

 

[Big Pepper]

Thank you so much, it works !!!
Mimy