Format help

[stephanieleshk]

I need to make 1 of my textboxes have currency format. I've changed that property and I get it on 1 box I changed and not the other 1 I changed. I would appreciate any help! Please and thank you!

 

[boblarson]

Are you sure that the other field in the text box that doesn't change is a number and not text?

 

[stephanieleshk]

Field

Ya I'm sure, it's actually a binary field that doesn't change.

 

[boblarson]

Binary field? In Access a binary is a true/false (-1,0). That would not resolve to currency. For currencies the Single, Double, and Decimal are the datatypes that need to be used.

Do you mean BYTE? If so it is an integer type from 0-255 and would not be a currency type.