Gustav Brock
Gustav at cactus.dk
Tue Sep 23 11:26:45 CDT 2008
Hi Rocky "needs" is too strong. As I wrote, Bit will do as well, and that is compatible with SQL Server so it might be a bit(!) easier to remember. /gustav >>> rockysmolin at bchacc.com 23-09-2008 18:05 >>> YesNo is what it needs to be. "I am replying from a machine without Access (can you believe that?)." No, it defies credibility. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Tuesday, September 23, 2008 7:47 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Change Field Type Rocky, I am replying from a machine without Access (can you believe that?). However, I think the clause "Boolean" is incorrect. I think it is something liked "Logical" or similar but I cannot quite remember and I cannot test for it. Try changing it to Logical and see if that works, if not Google for this clause. (It might even be YESNO or YES/NO or BIT) Good luck Max