I'm having the following problem with Access 97 and VB:

I'm using a TableDef to change the default values of various
fields in the database. The fields are text fields, 255
characters max, allowing empty strings, and not required.
I'm assigning the .fields(X).defaultvalue property to the
.text property of a listBox.

If I change the default value to an alpha string like
"Platinum", then it works fine. However, if I use a string
which begins with a number like "14 Karat" then I get a
Syntax error in "...table level validation".

Since this is obviously a program for a jeweler, most of the
strings will look like 14XXX or 18XXX or 22XXX.

The solution seems deceptively simple. Can anyone help?

-John