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

[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.

 

[Arvin Meyer [MVP]]

Set the format property of the text box to Currency.

 

[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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com