How do I eliminate the #1 from automatically appearing in blank fi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my mailing list database, the number 1 appears in any field that is blank.
How can I eliminate this?
 
Russ,

I suppose one possible explanation is the Default Value property for the
field (either in the design of the table or a form) has been set to 1
for some reason.

I suppose another would be that your form or report is based on a query
where the Nz() function has been used to return a 1 for blanks. If this
was the case, you would not see the 1 if you look at the table datasheet.
 
I appreciate your response. It seems to be beyond my expertise but, I'll try
to figure it out. Thanks
 
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

How does one eliminate blank records on a query result? 3
Eliminating records with #Num! 5
Find and Eliminate Duplicate records 3
Need Help With Wi-fi 5
Eliminate Duplicated 2
Showing combo box box that's not an option in its drop-down list 5
Unique entries 3
Duplicate records - eliminate from totals 11

Back
Top