Hiding Blank Data Fields on a Report
I have a Report that displays information about a Trading position that can be made up made up of at least 1, and up to 4 Orders. Each Trade Record within the database Table has fields for all 4 Orders and the details of each Order.
At present the Report displays the details of all Orders for a Trade, regardless of when the Orders have been issued or not, as indicated by the presence, or otherwise, of an order number:
Note that some fields have default values even when there is no Order Number.
What I wish to achieve is to have Orders that have not been issued NOT displayed in my Report, and the rows of the Report Detail without Order details shrunk. All Order fields in the Report are Textboxes:
I've tried putting the code show below in these events, without success:
Any suggestions on how to achieve this will be appreciated.
If IsNull(Me.Entry_Order_D) or Me.Entry_Order_D == "" then
Me!Entry_Order_D.Visible = False
Me!Trade_Entry_Price_D.Visible = False
Me!Entry_Fx_Conversion_Rate_D.visible = False
Me!Entry_Order_D.Visible = True
Me!Trade_Entry_Price_D.Visible = True
Me!Entry_Fx_Conversion_Rate_D.visible = True
Thanks in anticipation