Strings

[Becky]

I have a memo field that works most of the time - actually
always but what I have trouble with is when people type
the memo as I HATE WHEN THEY DO THIS. I can change it to
lower case by using LCase but then I need to capitalize
the first letter of each sentence and when they use "I". I
tried saying Comment: strConv([Comments],3)but then I get
I Hate When They Do This. Is there a solution and does
anyone know it?

Also, can you remind me how to sort number and letter so
1,111,2,222,a,aa,b,bb doesn't happen?

Thanks and have a great day

 

[Marshall Barton]

I have a memo field that works most of the time - actually
always but what I have trouble with is when people type
the memo as I HATE WHEN THEY DO THIS. I can change it to
lower case by using LCase but then I need to capitalize
the first letter of each sentence and when they use "I". I
tried saying Comment: strConv([Comments],3)but then I get
I Hate When They Do This. Is there a solution and does
anyone know it?

No way, only a human know what should and should not be
capitalized. Even grammar checking programs frequently get
it wrong.

How about you come in late some night and turn off their
Caps Lock key and then super glue it so it can never be
turned on again ;-)

Also, can you remind me how to sort number and letter so
1,111,2,222,a,aa,b,bb doesn't happen?

What do you want to happen? If you want it this way:

1a,1b,2,111,222,a,aa,b,bb,c,c123,d

then sort on the two calculated fields:
Val(field)
Mid(field, Len(Val(field)) + 1 )