Default value turning string to number

[spizotfl]

OK, I don't believe that is quite what is happening, but I can't find where it is being changed....
Here's the situation:
I have a field called ServicesID that looks like 1-01. It is a string value. When the user adds a new record, they can continue with the same ServicesID, and I use the defaultValue property to propagate this value. The problem is that instead of 1-01 showing on the new record, it is showing 0. If I just set the value directly, instead of using DefaultValue, it shows properly. I have double checked the underlying table fields and they are all text. I have tried changing the code that sets it from:
Me.txtServicesID.DefaultValue = servID
to:
Me.txtServicesID.DefaultValue = "" & servID & ""
but it still resolves it as numeric values. ServID is a string variable declared at the form level. It receives its value from OpenArgs when the form loads.
What am I missing?




"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut

 

[Remou]

I think you want:

"""" & servID & """"

 

[spizotfl]

Thanks for the quick response.
That works, but any ideas why that would work and what I was doing wasn't? That doesn't seem like the intuitive step one would expect just to set a string property with a string variable....

"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut

 

[Pampers]

I think this works too:

"'" & ServID & "'"

Pampers
Keeping it simple can be complicated

 

[Remou]

The underlying field may be a string, and the data may be a string, but I do not believe DefaultValue is a string.

http://msdn2.microsoft.com/en-us/library/aa194506(office.10).aspx

 

[ProgramError]

you could also try using str([servid])


Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.