#ERROR (1 Viewer)

[Harry Taylor]

Noob Question.
I have this control source in a text box;

=([Enquirymaster100 subform].[Form]![REF NO])

When the result is blank I get an #Error message.

How can I say if blank return blank?

 

[theDBguy]

I think Excel has ISERROR() but not sure if Access does. Otherwise, you may have to use an IIf() statement.

 

[Ranman256]

I made a function similar to NZ, called NZB() Null to Blank

USAGE:
= NZB([Enquirymaster100 subform].[Form]![REF NO])

Public Function NZB(ByVal pvVal)
On Error Resume Next
Select Case True
   Case IsNull(pvVal)
        NzB = NZ(pvVal, "")
   Case Else
      NzB = pvVal
End Select
End Function

 

[Josef P.]

Rename the control (e. g. textbox) from [REF NO] to txtREFNO ... then the data access runs via the AccessField element.

=[Enquirymaster100 subform]![REF NO] => should work
=[Enquirymaster100 subform]![txtREFNO] => #Error

 

[Eugene-LS]

When the result is blank I get an #Error message.

try IsError Function

=IIf(IsError([Enquirymaster100 subform].[Form]![REF NO]);0;[Enquirymaster100 subform].[Form]![REF NO])