|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
I created a report which displays several fields for each part. I need to devise a way in which only
the parts that have no values in these fields will be displayed. Keep in mind that I have an extremely large part list. Thanks for help! |
|
#2
|
|||
|
|||
|
That sounds like a big job that is not really inpossible.
to make a object disappear you need a macro. the following is for one field only 1) set action to "SetValue" 2) set condition to: [the_field_name] Is Null 3) At the bottom of window there are two text boxes. in the "item" box type: [the_field_name].[Visible] 4) In the expression box type: yes Repeat the process for the rest of the fields Good luck |
|
#3
|
|||
|
|||
|
Quote:
Try using code in the OnFormat event of the report: part1.visible = isnull(part1field1) ... |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > impossible access task |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|