mleiser Posted March 21, 2012 Posted March 21, 2012 Hope I'm in the right part of the forum. Here's what I need to do. You tab to Field 1 and enter the data. Based on Field 1 (if such and such) you either go to Field 2 for entry or Field 3. If you go to Field 2, based on the data in Field 1 you may either be sent to Field 3 where the data from Field 2 is copied but you are alklowed to change it, or based on that data in Filed 1 you may skip Field 3 and move on to Field 4. I hope I made it clear. Any help on that? Thanks, Mike
mleiser Posted March 21, 2012 Author Posted March 21, 2012 I have a database with Field 1 and Field 2. On a report, the body contains information per record including Filed 1 or Field 2. It's based on an IF statement. How do I get the report (if possible) to show either Field 1 or Field 2 based on that condition. Mike
LaRetta Posted March 21, 2012 Posted March 21, 2012 Please provide a small file showing an example of the logic and data and these four fields so we can understand the purpose and context of your request. Thank you. :^)
mleiser Posted March 21, 2012 Author Posted March 21, 2012 Field 1 = When a child is going to camp Field 2 = Childs bunk for July (only if they are coming in July) Filed 3 = Child bunk in August (only If they are coming in August. Also, if they are coming in August, automatically insert Julys bunk into August bunk with the ability for the user to change the August bunk. That's because most campers coming for July and August stay in same bunk) Field 4 = next filed - whatever it is Thanks
Lee Smith Posted March 21, 2012 Posted March 21, 2012 Automatic message This topic has been moved from "The Presentation Layer → Conditional Formatting" to "The Presentation Layer → Layouts". Please do no double post. I have merged your two topics.
comment Posted March 21, 2012 Posted March 21, 2012 How do I get the report (if possible) to show either Field 1 or Field 2 based on that condition. Try conditionally formatting both fields, so that one of them is displayed in 500-pt font size (which makes it invisible). Based on Field 1 (if such and such) you either go to Field 2 for entry or Field 3. I don't think that's possible in version 9. In later versions, you could use script triggers to override the layout's tab order.
mleiser Posted March 21, 2012 Author Posted March 21, 2012 In conditional formatting can you tell me how to set the size to 500 pt. I know there's a function where you give the field and the size, but in the conditional formatting you're already in that filed. Mike
comment Posted March 21, 2012 Posted March 21, 2012 Format > Conditional… > More Formatting… > Size: 500
Recommended Posts
This topic is 4638 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now