Data Type in table shows currency but on form it shows as Text Box.

P

p-rat

I'm trying to create an expression in a field. The field in the design
view of tables shows data type as currency; however, whenever I place
this field on my form it shows up as a text box.

How can I create an expression within a text box? Or how do I get the
data type to be correct on my form? I'm linking tables from SQL
backend to Access front end and it has given me some issues. Help
please. Thanks.
 
L

Linq Adams via AccessMonster.com

"whenever I place this field on my form it shows up as a text box."

Even following Arvin's advice, the field is still going to show up as a text
box! Textboxes on forms is where most data is entered, whether it be text,
numbers, dates or currency. Being in a "textbox" has nothing to do with the
datatype as defined in the table.
 
Top