I believe the lowest number your going to get is 1. You could however write a custom expression for the field to validate it if it's len() is 0. Just a thought.
..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Terry Troxel [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 8:41 AM To: CF-Talk Subject: Create / modify Access table in CF5 I have searched my archives and found a file called createtable.cfm That allows me to create a table in an existing Access datasource, but it does not allow me to define a field to allow zero length. Does anyone have a file you could share to allow me to do this? Terry Troxel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54