back with more!!

[potts]

I've now got a text box that is rounding the values copied to it up

e.g.

£9.50 copied in, value displayed and fed to underlying table as £10.00


Heeeeelllllpp!!!

 

[Tim K.]

The target field must be Integer or Long. Change it to Double or Single, depending on the maximum number you expect this field will hold.

 

[Tay]

What is the field size setting in your table? If for that field it is set to say, long integer - it will only store whole numbers, and round up or down. Maybe change the setting to 'single'.

HTH

 

[Bachfile]

I've had the same exact problem before:

Go to the table where the field is located.

Go to the design view.

Make sure you change the data type from ANY type of integer to decimal, and specify the number of decimals you'd like

That will fix the problem.

Cheers,

Bachfile

 

[Rich]

Since you display currency in this post and not percentage as elsewhere, we assume that it's currency values you are storing and therefore the fields data type should be Currency

 

[potts]

thanks guys