Inital Caps

[Guest]

I have tables that were pulls (imported) from Excel. Most of the data is
either Initial Caps or ALL CAPS. I want to make them all Initial Caps.

There is no data entry involved. As the data is already there. Plus if
there is any new data I want to force them to type in Inital Caps and NOT ALL
CAPS.

How can I do this?

 

[Rick Brandt]

I have tables that were pulls (imported) from Excel. Most of the
data is either Initial Caps or ALL CAPS. I want to make them all
Initial Caps.

There is no data entry involved. As the data is already there.
Plus if there is any new data I want to force them to type in Inital
Caps and NOT ALL CAPS.

How can I do this?

You can run a one-time update query to fix all existing data...

UPDATE TableName
SET [TableName]![FieldName] = strConv([TableName]![FieldName], 3)

For new entries about all you can do is use the AfterUpdate event of each
form control since I don't think there is any InputMask that can apply
Proper Case (plus InputMasks are evil ).

Me.ControlName = strConv(Me.ControlName, 3)

 

[Tom]

Remember it doesn't do mcDonalds and other annoying cases correct.

I have tables that were pulls (imported) from Excel. Most of the
data is either Initial Caps or ALL CAPS. I want to make them all
Initial Caps.

There is no data entry involved. As the data is already there.
Plus if there is any new data I want to force them to type in Inital
Caps and NOT ALL CAPS.

How can I do this?

You can run a one-time update query to fix all existing data...

UPDATE TableName
SET [TableName]![FieldName] = strConv([TableName]![FieldName], 3)

For new entries about all you can do is use the AfterUpdate event of each
form control since I don't think there is any InputMask that can apply
Proper Case (plus InputMasks are evil ).

Me.ControlName = strConv(Me.ControlName, 3)

 

[Mike Labosh]

Remember it doesn't do mcDonalds and other annoying cases correct.

Ding.

As an example, here's an *actual contact name* that came to me in an import
file"

"ATTN Mr Maj @#$%^* }{ Gen.Robert (Bob) Stevens van ter Hoffen-Schlager
Sr. MD, Computer Guy"

Put *that* in your pipe and parse it! (grrrr)
--
Peace & happy computing,

Mike Labosh, MCSD
"Working here is like living inside a Salvador Dali painting." -- Me. Yeah,
ME! [Oh fer cryin out loud]