Trouble with default values in a table

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

Guest

I have a table where all of the values are null, 0, or 1. If the record
happens to fall column 1 = 0, column 2 = 1 then access tries to complete the
series by making column 3 = 2 even though the default value is set to null.
Is there any way to turn this "auto complete" off? I'm using Access 2002.
Thanks in advance for any suggestions.
 
If you work in the tables (you shouldn't) or use a datasheet view,
AutoComplete remains on. The solution is to use a continuous form, which can
be made to look like a datasheet, if that's what is desired.
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access stripping decimal places in query 1
Check Box Default Value 8
Syntax to write a null value inside a sql Insert string? 1
Data Mismatch in Excel 2010 4
Adding default value to pre-existing table 2
Excel VBA 1
Excel Problem with SeriesCollection().Values 0

Back
Top