convert to title case?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
Click to expand...

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)
 
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

fredg said:
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
Click to expand...

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)
Click to expand...
 
Back
Top