Editing Text

[Guest]

Hello,

I need to edit several thousand records in an Access database. Primarily, I
need to change content such as "kbco technology" to "KBCO Technology." Using
the Instr function gets me partway there, to "Kbco Technology", but I need to
manually review/edit the records to apply the final touches when necessary.
It would be terrific if I could simply select the text, hit a key, and have
only what I've selected covert to CAPS!

Can anyone help? Thanks!

 

[Rick Brandt]

Hello,

I need to edit several thousand records in an Access database.
Primarily, I need to change content such as "kbco technology" to
"KBCO Technology." Using the Instr function gets me partway there, to
"Kbco Technology", but I need to manually review/edit the records to
apply the final touches when necessary. It would be terrific if I
could simply select the text, hit a key, and have only what I've
selected covert to CAPS!

Can anyone help? Thanks!

Use an Update query with the Replace() function.

 

[Guest]

Hi Rick,

Thanks for replying to this. Alas, I don't know how the Replace function
will help. I need to be able to manually review each record, selectioing each
unique portion of a field and making it all caps. In Word, I can just hit the
"Call Caps" button, but I can't find a similar function in Access.

Cheers,
Toby

 

[Guest]

Help! Anyone! Please!