Form Help

[samo1215]

I am trying to design some forms to make it easy for novice access users to input data. The problem I am having is I would like to limit the fields that a user sees depending on their selection of a dropdown box.



For instance, I have a field entitled "Events". If a person selects "Phone Call" from the "Events" drop down menu, I want to hide a couple of fields such as "Location", "Bid" and "Hire" so that there are not accidently completed. Is there a way to do this in acccess and if so, how?

[pbaldy]

Does this help?

http://www.baldyweb.com/ConditionalVisibility.htm

[samo1215]

Thank you for the response, I really appreciate the help. Your solution looks like it would work but admittedly, I am pretty new to Access and am not sure what property field to enter the code into.

Also, is there a way to then hide the blank fields when I generate a report with this data?

[pbaldy]

This may help with the first:

http://www.baldyweb.com/FirstVBA.htm

For the report, you can use the same technique in the format event of the section containing the controls. Since presumably they'll be empty anyway, you can use the Can Grow/Can Shrink properties of the textbox to impact the space taken up on the report.