TO CHANGE VISIBLE PROPERTY OF A FIELD 2

[desikan]

Hi,
I am using Access 2000. I am prepaing a
report having following fields : [item Name],[warranty],[FOB COST],expr1=[FOB COST]*0.3.
The last item is the repair cost of the item.

Now I want the report to contain the last field i.e the repair cost only when [warranty]="out of warranty". When [warranty]="under warranty", the repair cost field should be invisible.

Can anyone please help me to get this done?

R.Desikan

 

[cheiboy]

Try changing the visible property to NO in your design view.

 

[desikan]

Hi,
Thanks for your reply but it does not solve the problem.

I want the visible property to be set "no" automatically if [warranty] field is "under warranty". If [warranty] field is "out of warranty", then the visible property is to be set "yes".

R.Desikan

 

[GingerR]

in the Detail section of your report (in design view) you can put in the On Format event:

if me.warranty = "out of warranty" then
me.RepairCost.visible = false
else
me.RepairCost.visible = true
end if

if you do not know what i mean:
go to the design of the report
if you do not see the PROPERTIES panel already, choose VIEW+PROPERTIES from the menu bar.
click once on the grey bar that says DETAIL on it on the report design.
in the ON FORMAT event in the properties, choose [Event Procedure] and click on the little button to the right with the three dots on it. paste in the code above.

g

 

[desikan]

Thanks a lot.
Your code worked beautifully.

Thanks once again.

R.Desikan

 

[wrightpcs]

Did you consider using a Conditional Formatting? Set the font color to White if a certain criteria is met?