convert to title case?

[sally t]

Can I set an input mask or format that will convert ALL words in that field
to title case, even if there are several words?

Also (but unrelated), how do I trim leading spaces from a field?

Thanks.
Sally T

 

[mscertified]

I dont know what you mean by 'title case'?
However, I suggest you refer to HELP on 'Mask' as it will answer your
question.
to trim left, use the LTRIM() function. There is also an RTRIM() function
for trimming right and a TRIM() function for trimming both left and right.

Dorian

 

[fredg]

Can I set an input mask or format that will convert ALL words in that field
to title case, even if there are several words?

Also (but unrelated), how do I trim leading spaces from a field?

Thanks.
Sally T

Is This Your Idea Of Title Case?
Code the AfterUpdate event of the control in the Form used for data
entry:
Me![ControlName] = StrConv([Controlname],3)

 

[sally t]

Hello FredG, Yes, that's title case. Sorry, I'm not a developer, can you
give me step by step instructions - where do I write that code? Thanks.
SAlly t

Can I set an input mask or format that will convert ALL words in that field
to title case, even if there are several words?

Also (but unrelated), how do I trim leading spaces from a field?

Thanks.
Sally T

Is This Your Idea Of Title Case?
Code the AfterUpdate event of the control in the Form used for data
entry:
Me![ControlName] = StrConv([Controlname],3)