How to handle a blank feild

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

I am using = Me!Fld1 = Me!ControlName.Column(0) However the Fld1 is blank at
times. How do I handle this issue in code.
 
Perhaps the NZ function would work in this instance.

Me!Fld1 = NZ(Me!ControlName.Column(0),NullValue)

Where NullValue is the value you want to assign if the control has a Null
value.
 
I want the value to be Blank. I have tried to put " ". It still gives me an
error.
 
If the field is blank, and it's in a bound control on your form, the value
will actually be Null. By default a text field does not accept a zero length
string which is causing your error. You can set the property for the field to
accept a zero length string in table design

Me!Fld1 = NZ(Me!ControlName.Column(0),Null)
 
Back
Top