Hi,<br><br>I have a form with data I want to display as <br>"Standard". I know there an SQL keyword "CCur " that displays a field as Currency but ...<br><br>is there an MS Jet SQL keyword for the standard format?<br><br>Cheers.<br>Davo
MyValue = Somevalue<br>Don't put any convert function in front of it.<br>If you have your Table formatted in the Design view then the data will always show formatted.<br>Open your table in Design view click on the field in question.<br>Then Press F6 this will bring you to the bottom.<br>Look in the "Format" box. If there is something in it then your data will always be formatted.<br>I would remove this if you want it different somewhere else.<br>If you want it formatted sometimes then add formatting at your form or report.<br><br>OK<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.