Formatting existing data in fields.

[Rob]

Hi,

I was wondering if there was a way to format data using a macro in fields
that already exist.

e.g. I have a field called First that contains people's first name, but
often the first letter has not been capatilise ie robert instead of Robert.
Similarly I have a field called City and I would like to capatise all of the
characters in this field.

Any assistance would be appreciated.

Rob

 

[Steve Schapel]

Rob,

In the examples that you gave, you would use an Update Query to update
First to StrConv([First],3) and update City to StrConv([City],1)

 

[Rob]

Many thanks, I needed to open the data in a form to set some other values
and was trying to tidy up the data while doing so, but I used the the script
in a macro to set the value and it is working brilliantly,

Thanks

Rob

Rob,

In the examples that you gave, you would use an Update Query to update
First to StrConv([First],3) and update City to StrConv([City],1)

--
Steve Schapel, Microsoft Access MVP

Hi,

I was wondering if there was a way to format data using a macro in fields
that already exist.

e.g. I have a field called First that contains people's first name, but
often the first letter has not been capatilise ie robert instead of
Robert.
Similarly I have a field called City and I would like to capatise all of
the characters in this field.

Any assistance would be appreciated.

Rob