Number problems

[Xenix]

I have a problem, I want to click a button and the form to write to another form to select currency. but I keep getting the error: "The value you entered isn't valid for this field" I have the code:

Forms!Quotation!quotecurrency = Me.GBP

and both the fields are the same type:
Single 0.000#.##


thank you in advance

Mike

 

[saintsman]

Are you sure that they are the same data type? I've been caught out several times with this and found that I've had a text and a number field. So obvious that you become blind to it.

 

[Xenix]

Yes thank you,

I have checked it several times but it seem to be just number Single formatted to 3 decimals

 

[Rich]

Try
Forms!Quotation!quotecurrency = Format(Me.GBP ,"0.000#.##")

 

[Xenix]

Thank you Rich,

problem now is "Object doesn't support this property or method" ??

I have no idea

 

[saintsman]

Is the £ sign being inserted into your number field? (or is it attempting to).