SetValue

Alan Harrison

Registered User.
Local time
Today, 09:55
Joined
Jan 20, 2005
Messages
29
I've linked my inventory database to a table that holds data for my web site. Using a macro I can transfer the data in several field at the click of a button. I've run into a problem with one field called [SizeW] in my inventory and [width] in the web site db. [sizeW]is in meters and [width] needs to be in centimeters so I made my macro expression [sizeW]*100. The trouble is I get an incorrect result. 0.87 becomes 87.0000004768372 and so on. I have tried setting the format in the web site db to General Number and 0 decimals but this doesn't work. I can't think of anything that could be the cause.
PS
Any possibility this could be caused by a naming issue? I think 'width' might be a reserved terem for access.

TAI

Alan
 
I just put an unbound box on my form and made the source [sizeW]*100 and I got the same result so its nothing to do with the setvalue process!!
Al
 
I'd guess one or both fields have a Field Size of Double or Single, which are floating point numbers. If so, try Decimal instead.
 
That solved it? That drove me crazy the first time I ran into it.
 

Users who are viewing this thread

Back
Top Bottom