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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Displaying Currency 3
Showing Date Stamp on Form 6
Access Access - Is it possible to repeat fields in a form? 1
Text box and "Enter" 2
formatting a number in a text box 1
Formatting output text as currency 3
Data entry for a table from a form 1

Back
Top