Visible text

[lead 27]

Hi again

On my form I have a "last updated by" field which works fine, I have added a label to this field so it reads "this data was last updated by" then the "changed by" field

I want this to be where if the field is blank in the changed by the label is invisible I have used the code:

If Nz(Changed_By, "") = "" Then
Me.Label68.Visible = False
Else: Me.Label68.Visible = True
End If

The code works but I am not sure on which event to put it so that it will be invisible until someone updates that record.

 

[Rich]

Use the forms OnCurrent event, in the AfterUpdate event put
Call Form_Current

 

[lead 27]

That works great thank you I would never have figured that out

Thanks

 

[lead 27]

So that I am not just copying codes etc can anyone explain why the code works e.g. what the Nz( ) means and how it works with the on current and then after update events e.g what happens with call form_current?

Thanks

 

[The_Doc_Man]

NZ and events can be found with Access Help

NZ does not change meanings from one event context to another. But its inputs might.