> How can I put a ' ' (ie. a space) as a default expression for a field

(using

> the editor an not the BeforePost event)?

I think you have to be careful of the BLANKISNULL setting and not use the
fancy editor for the query but directly put the entry in the stringlist from
the object inspector with a blank. The editor puts the column names in there
with a blank and then removes them for you. As a result, it creates a blind
spot in having things default as a blank.

You might also allow it to be NULL and then in the trigger on the server
check if it is null and change it to a blank string. That is what I do.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com