Dealing with a possible Null in a text string

[hpl2001]

Hello:

I have this line in the update code of a form:

Me.txtTrackingInfo = "Reactivated: " + Me.cboFacility + "/" + Me.txtTransferNumber + "/" + Me!frmBoxSub![Schedule Number] + "/" + Me!frmBoxSub!Location + "/" + Format(Now, "yyyy-mm-dd") + "/" + Environ("Username") + vbNewLine + Me.txtTrackingInfo

Sometimes the Me!frmBoxSub!Location field does not have any information in it. When this is the case, my entire txtTrackingInfo field goes blank. How can I deal with the possibilty that this Location field might be empty?

TIA!

Holly

 

[PHV]

Use the & operator instead of +

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hpl2001]

Thanks! That was it...