Remove First Character

[Juan4412]

Textbox on form, sometimes people are adding a comma to start the text or a space to add the text, is there a way to trim the string if the first character is a text or a space? To make it more difficult (for me at least) it is concatenating 2 fields so I can't just simply use the left function to trim the 1st 2 characters.



My current syntax is this:

CombineTextFields: [textbox1] &" "+[textbox2]

[June7]

Try:

Trim(Replace(textbox1,",",""))

[Juan4412]

Try:

Trim(Replace(textbox1,",",""))

That removes all commas from the string, I only want to remove it if it is the 1st two characters in the string.

[June7]

Consistency is critical in string manipulation. Otherwise gets complicated. The comma could be first or preceded by space?

[Juan4412]

Correct it will either be space, or ,space those are the 2 scenarios that I am trying to "idiot proof" and go ahead and remove if possible from the query resul.ts.

[June7]

No such thing as 'idiot proof' - always a better idiot.

But try:

IIf(Left(Trim(textbox1),1)=",", Mid(Trim(textbox1),2), Trim(textbox1))

[June7]

If this is something you can control during data entry, suggest you do it there so don't have to do this manipulation every time you want to build a query.

Code behind form in textbox AfterUpdate event can do this correction and make sure data is saved properly.

If Not IsNull(Me.textbox1) Then Me.textbox1 = IIf(Left(Trim(textbox1),1)=",", Mid(Trim(textbox1),2), Trim(textbox1))