Blazer Saga
Registered User.
- Local time
- Today, 08:05
- Joined
- Jan 22, 2007
- Messages
- 12
Ok this is a two prater.
First I need to figure out how to change the background color of a txt field in a report based on its value when the report is viewed.
More specifically, I have a report in witch I want to the add the functionality that if a field is blank, but they should have put info in it based on other selections, it's background will be yellow. I don't want to simply alter the Forms they use to generate this data to make the fields required, because in many cases threw out the form, these fields are hidden from view based on other selections and therefore they can not enter data into them.
I have red the help documentation about the BackColor value, but I am unable to get it to change the BackFill color even with a simple
Dim BGYellow As Long
BGYellow = RGB (255, 255, 0)
Me!Cmb_Font_Style.BackColor = BGYellow
I am also unsure witch function in a report I should place this under so it checks the data when it opens up. I am assuming the report Open() call is the correct one.
Now for the second part.
In the forms they fill out there are many Combo Boxes, these are linked to tables via a Number (Form side) - Autonumber (Table with the combo data) arrangement. So the value actually stored in the form I am generating this report from are numbers. I need to display the text stored in another filed in that table inside a text box on the report.
At first I tried making a query and pointing the text box to that, but I had no luck. So I am wondering how I should accomplish this if its even possible. Do I need to use some form of a query (If so is there some way to call it from code rather then make separate queries under the queries tab so I can keep the database looking nice) or is there another way?
First I need to figure out how to change the background color of a txt field in a report based on its value when the report is viewed.
More specifically, I have a report in witch I want to the add the functionality that if a field is blank, but they should have put info in it based on other selections, it's background will be yellow. I don't want to simply alter the Forms they use to generate this data to make the fields required, because in many cases threw out the form, these fields are hidden from view based on other selections and therefore they can not enter data into them.
I have red the help documentation about the BackColor value, but I am unable to get it to change the BackFill color even with a simple
Dim BGYellow As Long
BGYellow = RGB (255, 255, 0)
Me!Cmb_Font_Style.BackColor = BGYellow
I am also unsure witch function in a report I should place this under so it checks the data when it opens up. I am assuming the report Open() call is the correct one.
Now for the second part.
In the forms they fill out there are many Combo Boxes, these are linked to tables via a Number (Form side) - Autonumber (Table with the combo data) arrangement. So the value actually stored in the form I am generating this report from are numbers. I need to display the text stored in another filed in that table inside a text box on the report.
At first I tried making a query and pointing the text box to that, but I had no luck. So I am wondering how I should accomplish this if its even possible. Do I need to use some form of a query (If so is there some way to call it from code rather then make separate queries under the queries tab so I can keep the database looking nice) or is there another way?