M
Max Moor
Hi All,
I have a field in a table that needs to, at different times, hold a
dollar amount, a percentage, or a whole nummber, depending on the context
of some other record data.
I have a form with a textbox for data entry. Depending on the
record's context, I set the textbox's format to "Currency," "0%," or just
"0."
The problem is that, when the textbox is set to "Currency", and I put
the curor in it to edit the field, the dollar amount displayed turns into a
huge integer (I assume the actual single value).
I'm obviously doing something wrong. Can anyone tell me what I
should be doing?
- Max
I have a field in a table that needs to, at different times, hold a
dollar amount, a percentage, or a whole nummber, depending on the context
of some other record data.
I have a form with a textbox for data entry. Depending on the
record's context, I set the textbox's format to "Currency," "0%," or just
"0."
The problem is that, when the textbox is set to "Currency", and I put
the curor in it to edit the field, the dollar amount displayed turns into a
huge integer (I assume the actual single value).
I'm obviously doing something wrong. Can anyone tell me what I
should be doing?
- Max