Have a form with a text box on it. the format of the text box is set to Currency, 2 decimal places.
I am propagating this field from a Global defined as Price$.
I propagated this Global from Vba code via a read on a table (Price$ = rst.unitprice)
in the table, the field is defined as currency with 2 decimal places.
when i look at the table in datasheet view, the data appears as "$185.00"
but, in my text box on the form, it appears as "185"
the decimal places are missing as well as the dollar sign.
I looked at the data (stepping through the code using the F8 key and in the Price = rst.unitprice statement, the value that appears in the rst.unitprice is "185" !
is there a way to force the data in the text bos on the form to appear as it does in the table in datasheet view ? i.e. as "$185.00" instead of "185" ?
thanks !
Paul
I am propagating this field from a Global defined as Price$.
I propagated this Global from Vba code via a read on a table (Price$ = rst.unitprice)
in the table, the field is defined as currency with 2 decimal places.
when i look at the table in datasheet view, the data appears as "$185.00"
but, in my text box on the form, it appears as "185"
the decimal places are missing as well as the dollar sign.
I looked at the data (stepping through the code using the F8 key and in the Price = rst.unitprice statement, the value that appears in the rst.unitprice is "185" !
is there a way to force the data in the text bos on the form to appear as it does in the table in datasheet view ? i.e. as "$185.00" instead of "185" ?
thanks !
Paul
