Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2003
    Posts
    41

    Unanswered: Simple Textbox formatting Question

    Good day,

    I have to restrict entry on my textbox to MM-YYYY. I have tried input mask and putting MM-YYYY in the "Format" section of the properties. But when it submits to the table it shows as dates like "01-1900" & "07-1894".

    Any advice?

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    so what's the problem?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jun 2004
    Posts
    55
    I assume you want to be able display is like Jan-1985 or something?

  4. #4
    Join Date
    Jul 2003
    Posts
    41
    Sorry for the confusion. But if I enter 06-2004 it shows as 01-1900 or some crazy thing. But I have decided to get the user to enter full date.

    Thanks

  5. #5
    Join Date
    Jul 2003
    Posts
    41

    Formatting a students grade in a textbox

    Thanks for help for the last one, I have it now.

    But now I am looking for similar help with regards to a students grade. I have the textbox and I want enter for example 95.52 or 77.52 or 52.22 or even 100.00. Just wondering what type of imput mask I can use for this. I tried 000.00 but if I typed 95.52, access wouldn't let me move to the next box.

    Any suggustions?

    Thanks

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    format -> fixed
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Jun 2004
    Posts
    55
    Change the format on the textbox to Fixed

  8. #8
    Join Date
    Jul 2003
    Posts
    41
    Thank you.

Posting Permissions

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