Show field if there is data in another

[hobbit2612 via AccessMonster.com]

Hi I wonder whether someone can help me a with a problem I have.

I have a report which contains tracked data changes. What I would like to do
is where for example the 'DateOfInvoiceChanged' field is populated with a
date, I would like the 'DateOfInvoice' i.e. the associated field to be
visible, but, I'm not quite sure where to start to be honest.

Could someone perhaps point me in the right direction please?

Many thanks

Chris

 

[Marshall Barton]

I have a report which contains tracked data changes. What I would like to do
is where for example the 'DateOfInvoiceChanged' field is populated with a
date, I would like the 'DateOfInvoice' i.e. the associated field to be
visible, but, I'm not quite sure where to start to be honest.

You can use the Format event procedure:
Me.DateOfInvoice.Visible = Not
IsNull(Me.DateOfInvoiceChanged)
(all on one line)

A less versatile, but maybe adequate in your case would be
to use an expression in the DateOfInvoice text box:
=IIf(DateOfInvoiceChanged Is Null, Null, DateOfInvoice)

 

[hobbit2612 via AccessMonster.com]

Marshall,

That's great. I used the second piece of coding and it works a treat!

Many thanks for your time and trouble

Regards

Chris