Editing Text

T

Toby Gadd

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!
 
R

Rick Brandt

Toby said:
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!
Click to expand...

Use an Update query with the Replace() function.
 
T

Toby Gadd

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
 
Top