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

  • Thread starter Thread starter p-rat
  • Start date Start date
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.
 
"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
 
Back
Top