I need to change Upper case text to Proper

  • Thread starter Thread starter Jay Oken
  • Start date Start date
J

Jay Oken

Is there a way to do this using a query. I have tried using =Proper but this
does not work (appears to be exclusive to Excel).

I am using Access 2000.

Thanks,
Jay
 
You can do this using a calculated field in a query. The field box in the
query design grid would look something like this:

CorrectedToProperCase: StrConv([TableName].[FieldName], vbProperCase)
 
Thanks Wayne but I could not get this to work. I tried putting this in the
field box of both a select and an update query but it treated vbProperCase
as an input variable. What am I doing wrong?

J


Wayne Morgan said:
You can do this using a calculated field in a query. The field box in the
query design grid would look something like this:

CorrectedToProperCase: StrConv([TableName].[FieldName], vbProperCase)

--
Wayne Morgan
Microsoft Access MVP


Jay Oken said:
Is there a way to do this using a query. I have tried using =Proper but this
does not work (appears to be exclusive to Excel).

I am using Access 2000.

Thanks,
Jay
Click to expand...
Click to expand...
 
In a query, you need the value of the variable - I believe that is 3 for propercase.

CorrectedToProperCase: StrConv([TableName].[FieldName], 3)

Jay said:
Thanks Wayne but I could not get this to work. I tried putting this in the
field box of both a select and an update query but it treated vbProperCase
as an input variable. What am I doing wrong?

J

Wayne Morgan said:
You can do this using a calculated field in a query. The field box in the
query design grid would look something like this:

CorrectedToProperCase: StrConv([TableName].[FieldName], vbProperCase)

--
Wayne Morgan
Microsoft Access MVP


Jay Oken said:
Is there a way to do this using a query. I have tried using =Proper but this
does not work (appears to be exclusive to Excel).

I am using Access 2000.

Thanks,
Jay
Click to expand...
Click to expand...
Click to expand...
 
Back
Top