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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parse Feild 4
Field order in the Querydef 2
Carry the field 2
Multi-field Primary keys 8
how to debug.print sql statement with parameter values? 1
Append table with If then else 2
Changing Field Position not working 3
iif Function in Query 7

Back
Top