Replace Value in String

[Chris]

Hi

I have the value of a piece JH32-1 and I want to replace
the value 32 by XX

The value of the piece are from JH32-1--> JH32-99 and I
have JB32-1 --> JB32-99

Can I do the replacement by code, instead of do it
manually

thanks

 

[RobFMS]

Chris

In Access 2000 and up, there is a vba function called "Replace()".
The help file and intelli-sense should be helpful for you.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Bruce M. Thompson]

Just to add to what Rob has suggested, if you want only to change that value
where the field's value begins with "JH" (this may *not* be what you were
implying), you will need to test for that condition before executing the
Replace().

'***In Code
If Left([FieldName], 2) = "JH" Then
'Do the replace
End If
'***

Using SQL, you can set the criterion to:

Left([FieldName], 2) = "JH"