Formatting existing data in fields.

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
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)
 
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


Steve Schapel said:
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
Click to expand...
Click to expand...
 
Back
Top