Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to strip string characters from a data field

Status
Not open for further replies.

rew2009

Technical User
Apr 21, 2009
114
US
I have a form where I am displaying string data in a text box. I tried using a command button with the following code from vb to strip the first two characters and display the result in a second textbox:

Dim strImagenumber As String

' StripLeftNCharacters("123456789", 3) = "456789"

strImagenumber = StripLeftNCharacters(Me.Text454.VALUE, 2)

Me.Text629.VALUE = strImagenumber

Does access use the vb function "StripLeftNCharacters", if it does is my syntax wrong, and if it doesn't what is the correct code?

Thanks, Russ
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top