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

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).

hi paul

that was bulls eye

thank you

krishnanhemanth