Capitalizing

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

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!
 
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
 
Try --
strconv([YourField], 3)

1 = ALL CAPS
2 = all lower case
3 = Initial Caps For Each Word
 
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
 
Hi!
Thanks. I'm going with this idea.


KARL DEWEY said:
Try --
strconv([YourField], 3)

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

juicegully said:
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!
Click to expand...
Click to expand...
 
Back
Top