hide / view based on value

[krishnanhemanth]

hi everybody

i have a customization needed on my report

i have 4 textboxes

1> partname
2> partnumber
3> type of sales
4> product

the "TYPE OF SALES" can be either "product sales" or "spares sales"

if the "type of sales" value is "product sales" then i want the "partname" and the "partnumber" textbox to be hidden

i have tried out this

on report load
if me.typeofsales.value = "product" then
me.partname.visible=false
me.partnumber.visible = false
else
me.partname.visible=true
me.partnumber.visible = true
end if
THIS IS NOT WORKING. WHERE AM I WRONG..PLEASE HELP
krishnanhemanth

 

[pbaldy]

You don't want it in the load event, you want it in the format event of the section containing the textboxes (probably the detail section).

 

[krishnanhemanth]

hi paul

that was bulls eye

thank you

krishnanhemanth