formatting please help!

[Angela Pasch]

I know how to make text either all CAP or all lower case,
or capitalize the first letter of each word (as for
addresses and names, etc.) but I can not fnd out how to
make the text proper so that when users are in the form
and they enter all caps or all lower case Access converts
it to proper sentence structure. for example:
"I AM ENTERING THE DATA IN UPPER CASE" would change to "I
am entering the data in upper case".

Please help, I appreciate your assistance.
Angela

 

[fredg]

I know how to make text either all CAP or all lower case,
or capitalize the first letter of each word (as for
addresses and names, etc.) but I can not fnd out how to
make the text proper so that when users are in the form
and they enter all caps or all lower case Access converts
it to proper sentence structure. for example:
"I AM ENTERING THE DATA IN UPPER CASE" would change to "I
am entering the data in upper case".

Please help, I appreciate your assistance.
Angela

Code the control's AfterUpdate event:
[ControlName] = UCase(Left([ControlName],1)) &
LCase([Mid([ControlName],2))

How do you intend to handle a sentence like this?
I sent John O'Connor to the McDonald's next to the IBM building to get
some cold Pepsi's.

 

[Douglas J. Steele]

I know how to make text either all CAP or all lower case,
or capitalize the first letter of each word (as for
addresses and names, etc.) but I can not fnd out how to
make the text proper so that when users are in the form
and they enter all caps or all lower case Access converts
it to proper sentence structure. for example:
"I AM ENTERING THE DATA IN UPPER CASE" would change to "I
am entering the data in upper case".

Please help, I appreciate your assistance.
Angela

Code the control's AfterUpdate event:
[ControlName] = UCase(Left([ControlName],1)) &
LCase([Mid([ControlName],2))

How do you intend to handle a sentence like this?
I sent John O'Connor to the McDonald's next to the IBM building to get
some cold Pepsi's.

I sent him to the fast food outlet next to the big corporate building to get
some cold caffenated sodas?

 

[Jeff Conrad]

I sent him to the fast food outlet next to the big corporate building to get
some cold caffenated sodas?

LOL, that was good.


--
Jeff Conrad
Access Junkie
Bend, Oregon

I know how to make text either all CAP or all lower case,
or capitalize the first letter of each word (as for
addresses and names, etc.) but I can not fnd out how to
make the text proper so that when users are in the form
and they enter all caps or all lower case Access converts
it to proper sentence structure. for example:
"I AM ENTERING THE DATA IN UPPER CASE" would change to "I
am entering the data in upper case".

Please help, I appreciate your assistance.
Angela

Code the control's AfterUpdate event:
[ControlName] = UCase(Left([ControlName],1)) &
LCase([Mid([ControlName],2))

How do you intend to handle a sentence like this?
I sent John O'Connor to the McDonald's next to the IBM building to get
some cold Pepsi's.

I sent him to the fast food outlet next to the big corporate building to get
some cold caffenated sodas?

 

[fredg]

I know how to make text either all CAP or all lower case,
or capitalize the first letter of each word (as for
addresses and names, etc.) but I can not fnd out how to
make the text proper so that when users are in the form
and they enter all caps or all lower case Access converts
it to proper sentence structure. for example:
"I AM ENTERING THE DATA IN UPPER CASE" would change to "I
am entering the data in upper case".

Please help, I appreciate your assistance.
Angela

Code the control's AfterUpdate event:
[ControlName] = UCase(Left([ControlName],1)) &
LCase([Mid([ControlName],2))

How do you intend to handle a sentence like this?
I sent John O'Connor to the McDonald's next to the IBM building to get
some cold Pepsi's.

I sent him to the fast food outlet next to the big corporate building to get
some cold caffenated sodas?

Chalk up a good one for you. <g>