Capitalizing

[Guest]

Hi,

Is there a way to have a table store text wtih the first letter capitalized?
Perhaps something in the Format property? I've looked into Formatting text
but only see how to capitalize all letters of text. I would go and have an
After_Update event for each text box, but I have many text boxes now.

Thanks!

 

[tina]

formatting controls how the data in a table is *displayed*, not how it is
*stored*. if you want to store the data as Sentence Case, but you don't want
to use the AfterUpdate event in specific controls on a form....hmm, well, i
suppose you could add code to the form's BeForeUpdate event to loop through
the textbox controls and change the values to Sentence Case. that would save
putting code on each control's AfterUpdate event.

hth

 

[Guest]

Try --
strconv([YourField], 3)

1 = ALL CAPS
2 = all lower case
3 = Initial Caps For Each Word

 

[tina]

btw, my suggestion will work (or not <g> ) regardless of what change you're
making to the data. if you want Title Case, then use the StrConv() function
in the loop (see function options in KARL's reply in this thread). but if
you want Sentence Case, AFAIK there's no function available for that in
Access. you'll have to write a function yourself, to parse the data in each
field.

hth

 

[Guest]

Hi!
Thanks. I'm going with this idea.

Try --
strconv([YourField], 3)

1 = ALL CAPS
2 = all lower case
3 = Initial Caps For Each Word

Hi,

Is there a way to have a table store text wtih the first letter capitalized?
Perhaps something in the Format property? I've looked into Formatting text
but only see how to capitalize all letters of text. I would go and have an
After_Update event for each text box, but I have many text boxes now.

Thanks!