The Access IDE will trim strings.
If you have a field set to not accept empty strings, then empty strings will
automatically be converted to nulls.
If the field is a primary key field, the null will be rejected.
Jet/ADO/DAO do not trim strings, so you can add white space strings to a Jet
database by using ADO/DAO.
Some types of SQL Server string fields trim strings, and will not allow you
enter whitespace strings.
(david)
"shallow" <de*********@yahoo.com> wrote in message
news:e3*************************@posting.google.co m...
Hi all,
msaccess (2003) seems to be unable to cope with whitespace strings:
let's assume a table with a text field as primary key.
now enter a new record that has a number of spaces and only spaces in
the primary key field.
msaccess will complain and claim "index or primary key cannot contain
a Null value".
a string of spaces is clearly not a null value.
am i missing something ?
is there some option to control this behaviour?
any help greatly appreciated