Help with Replace Function...

[redbull]

I have a textbox on a form, its value is determined by a record...

Forms("frmmainnew").Text311.Value = r![F3]

That is working great... but here is the problem. The data from that record is always formatted like this...

", 38972,"

I need to have it formated like this

"38972;"

SO I need the leading ", " dropped. Then all the following ", " turned into ";"

I have tried this...



Forms("frmmainnew").Text311.Value = Replace(r![F3], ", ", ";")

but this changes the text box to this.

;38972,


any ideas?

[Perceptus]

hows this do for ya?

Forms("frmmainnew").text311.value = val(r![F3])

[redbull]

It left me with a 0 in the textbox field.

[RuralGuy]

How about:
Forms("frmmainnew").Text311.Value = Replace(r![F3], ",", "") & ";"

[redbull]

beautiful, thank you both. Working great now!

[RuralGuy]

Great! Glad we could help.