Forum Discussion

Copper Contributor

Mar 18, 2023

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

excel

NikolinoDE

Platinum Contributor

Mar 18, 2023

TINHAMMER9095

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.

NikolinoDE

I know I don't know anything (Socrates)

TINHAMMER9095

Copper Contributor

Mar 31, 2023

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.

NikolinoDE
Platinum Contributor
Apr 01, 2023
TINHAMMER9095
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!
HansVogelaar
MVP
Mar 31, 2023
TINHAMMER9095

Unfortunately, it is not possible to customize the Data Form. You'd have to create your own userform in the Visual Basic Editor.