Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    63

    Unanswered: SQL - "format/input mask" in DDL

    I am creating a DB with access 2002 and I have to create the DDL for the tables involved. Is it possible in access to implement the 'format' and 'input mask' attributes of a field in SQL or does this have to be done manually afterwards?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    At least in my opinion, the "format" and the "input mask" attributes are something that the GUI deals with, not the data engine. As such, they ought to be dealt with in the language doing the GUI (in the case of MS-Access that would be VBA), not the language doing the data management (in the case of MS-Access that would be Jet, a pseudo-SQL).

    -PatP

  3. #3
    Join Date
    Jun 2002
    Posts
    63
    Thanks, that's what i thought wold be the case.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •