 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / May 2008notation
Hi, I designed a table with a "phone"-field.. I want it to look like 03/775.99.82 In notation I wrote: 00/000.00.00 When I go to the next field access changes this to: 00\/0.000.000 What am I doing wrong? Should I make the field text or numeric Should I use # instead of 0 I'm completely confused... any help is welcome Thanks JP >Hi, >I designed a table with a "phone"-field.. [quoted text clipped - 4 lines] > >What am I doing wrong? Nothing. The \ is a "quote" character in input masks and formats, meaning that the next character should be taken literally. This simply means that upi want a literal virgule (/) character inserted. >Should I make the field text or numeric Text, absolutely. >Should I use # instead of 0 # for Formats; 0 or 9 for Input Masks depending on whether you want the number to be required or optional (I'd expect 0 in this case). >I'm completely confused... any help is welcome > >Thanks >JP  SignatureJohn W. Vinson [MVP] i'm confused... What is the difference between notation and validation? Thanks JP >>Hi, >>I designed a table with a "phone"-field.. [quoted text clipped - 25 lines] >>Thanks >>JP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.