Forum Discussion
Automated Form for use with Microsoft Excel Table
I am new to using Microsoft Excel Tables. However, I did create a table with a field named SalePrice. The entry in the first row is shown in the Table as $34,012.50. When I created a form for this table entry in the SalePrice field shows 34012.5. Is there any way to make the form SalePrice field have the same format as the Table SalePrice field?
Thanks for your help.
I did post this on Excel Forum also but have not received a response.
4 Replies
One possible way to make the form SalePrice field have the same format as the table SalePrice field is to use the FormatCurrency function. This function returns an expression formatted as a currency value using the currency symbol defined in the system control panel. You can use this function in the Control Source property of your form field, like this:
=FormatCurrency([SalePrice])
This will display the value of SalePrice with a dollar sign and two decimal places. You can also specify other arguments for this function, such as how many decimal places you want, whether to use parentheses for negative numbers, and whether to group digits
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
- Sorry for the long delay in responding to your reply. I do not know how to access the Control Source property for the Data Form created by Microsoft. It seems this form appears magically by Microsoft Excel and I don't know how to access the basic form to modify it. Any suggestions, I am rather frustrated at this point.
Thanks for your response.If the data form is there and you can't find it...
You can modify an Excel Data Form by adding the Form button to the Quick Access Toolbar.
To do this, click the arrow next to the Quick Access Toolbar, then click More Commands.
In the Choose commands from box, click All Commands, and then select the Form button in the list. Click Add, and then click OK .
If the data form is deleted/doesn't exist and you can't find it with it...
To create a new record using the data entry form in Excel, you can follow these steps:
- Select any cell in your table.
- Click on the Form button on the Quick Access Toolbar or on the ribbon.
- In the input form, click the New button.
- Type the information in the appropriate fields.
- When done, hit the Enter key or click the New button again. This will add the record to the table and get a blank form for the next record.
If you don’t see the Form button on your Quick Access Toolbar or ribbon, you can add it by following these steps:
- Click the arrow next to the Quick Access Toolbar, and then click More Commands.
- In the Choose commands from box, click All Commands, and then select the Form button in the list.
- Click Add, and then click OK.
Otherwise you would need to see the file in order to be able to say more precisely.
I hope this helps!
