By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Using an if statement to show a field

P: 2
What I want to do is create an if statement that basically says "If Has_Returned=Yes (I'm using a Yes/No for Has_Returned) then show Return_Date, else, hide return date." Does anybody have any idea on how to do this. IF someone could preferably show me how to do this using a macro, that would be awesome!

Nov 14 '13 #1
Share this Question
Share on Google+
4 Replies


P: 16
In your form on current event put the following code

return_date.visible=has_returned
Nov 14 '13 #2

P: 2
Sorry, I'm not exactly a professional on Access. What do you mean by current event?
Nov 14 '13 #3

P: 16
if you open the form properties, click on the events tab and you will see current event. Click in the 3 dot button to the right and select code builder. If you are happy with macros then this should e familiar to you
Nov 15 '13 #4

zmbd
Expert Mod 5K+
P: 5,397
Jjrage:
Please keep in mind that many of us are not able to see/review images stored in sites such as TinyPic from work PCs due to IT restrictions - especially those of us in the U.S. where companies can easily run into legal issues. This is the situation I am in with trying to help you.

Because you relied on the image to provide the detail, there is not enough information for many of us to provide help. If you will clearly explain what you are after we may be able to salvage this thread.

We also need to know which version of Office/Access and which operating system you are using as there are some slight differences (with Macros, a ton of difference!).

Thnx
-z
Nov 19 '13 #5

Post your reply

Sign in to post your reply or Sign up for a free account.