I am working on creating an contract and inventory database. When I select under category I created a drop box showing new, upgrade or maintenance. If they select the first two I would like the maintenance term, maintenance beginning and maintenance end dates to 'grey' out if possible. Only if they select maintenance should those fields be adjustable.

On a separate thing, is there a way to force entry into a field that shows purchase amount to have standard currency settings (in other words a dollar sign, a comma and a decimal point)?

For your first question, do an advanced search on these forums for +visibility and you should come across some threads with a technique to hide fields. This may help you.

As for your second question, you dont have to have them enter in the data with those settings. Actually I would just recommend that they enter in numbers and a decimal if needed.

You can format the fields to display with the currency symbol, set the decimal points, and comma, etc. This can be done by selecting the fields in layout mode and then either right click and select format number or you can do it from the format menu item on the top as well.

actually after stumbling around a lot I found that you can set the number field to show currency and include (or exclude) commas and the location of a negative (in front or behind the dollar symbol).

I also found that there is a way to bring up a calendar on a date field. Now to try out your ideas on greyed out fields.