isbn zila 24.07.2006 16:08:02 1. l failed to enter ISBN number in my form. For details; Field Name; ISBN number Data type : Number Field Size;Long Integer Decimal places: Auto Note; please tell me what should l do? 2. l'm using short date .when l enter 11/12/2006 it changes to 12- Nov-2006 but if l enter 23/12/2006 it's o.k (23-Dec-2006).l realise that all numbers below than 12 give me headache for example 4/12/2006 will change to 12-apr-2004 or 3/5/2006 will change to 5-mar-2006. What should l do to get input 4/12/2006 such as 4-dec-2006 automatically .l don't like to write month before day. thank you

RE: isbn Jerry Whittle 24.07.2006 16:27:02 1. I don't understand the question. 2. Access tries to guess dates when you enter them. As there is no 23rd month, but a 12th month, Access guess correctly when you enter 23/12/2006. However if the date can be interpreted more than one way, Access defaults to the ANSII standard where A is for American. Therefore Access, and SQL, perfer the MM/DD/YYYY format. There's not much you can do except for put in the MM/DD/YYYY format; spell out the month like "4-dec-2006", or use the YYYYMMDD format such as 20061204 which Access and SQL both like. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "zila" wrote: [Quoted Text] > 1. l failed to enter ISBN number in my form. For details; > Field Name; ISBN number > Data type : Number > Field Size;Long Integer > Decimal places: Auto > Note; please tell me what should l do? > > 2. l'm using short date .when l enter 11/12/2006 it changes to 12- Nov-2006 > but if l enter 23/12/2006 it's o.k (23-Dec-2006).l realise that all numbers > below than 12 give me headache for example 4/12/2006 will change to > 12-apr-2004 or 3/5/2006 will change to 5-mar-2006. What should l do to > get input > 4/12/2006 such as 4-dec-2006 automatically .l don't like to write month > before day. > > thank you

Re: isbn "Joan Wild" <jwild[ at ]nospamtyenet.com> 24.07.2006 18:52:51 zila wrote: [Quoted Text] > 1. l failed to enter ISBN number in my form. For details; > Field Name; ISBN number > Data type : Number > Field Size;Long Integer > Decimal places: Auto > Note; please tell me what should l do? You don't indicate what the problem is, however a ISBN # isn't really a number. Make it a text field instead. > 2. l'm using short date .when l enter 11/12/2006 it changes to 12- > Nov-2006 but if l enter 23/12/2006 it's o.k (23-Dec-2006).l realise > that all numbers below than 12 give me headache for example 4/12/2006 > will change to 12-apr-2004 or 3/5/2006 will change to 5-mar-2006. > What should l do to get input > 4/12/2006 such as 4-dec-2006 automatically .l don't like to write > month before day. Access uses the short date format as specified in the Regional Settings of Control Panel on the computer. It is likely that your computer is set to mm/dd/yyyy and therefore 11/12/2006 is indeed Nov 12, 2006. 23/12/2006 - well that doesn't conform to the Regional settings as there is no 23rd month. So Access is being 'helpful' and spins around your entry until it does find a valid date - in this case Dec 23, 2006. If you prefer to enter dates as dd/mm/yyyy then change this setting in the Control Panel. Note that this will affect all programs where you enter a date. The format you've chosen is good, as it shows an unambiguous format and you can tell right away whether your entry has been interpreted as you meant. -- Joan Wild Microsoft Access MVP

Re: isbn "onedaywhen" <jamiecollins[ at ]xsmail.com> 25.07.2006 11:40:18 Jerry Whittle wrote: [Quoted Text] > There's not much you can do except for put in the MM/DD/YYYY format; spell > out the month like "4-dec-2006", or use the YYYYMMDD format such as 20061204 > which Access and SQL both like. You can use the ISO 8601 format yyyy-mm-dd. Access likes to muck about with the dates and makes them 'US format', in which case they can be text literals e.g. CDATE('2006-12-04') Jamie. --