Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    77

    Red face Unanswered: Text field keeps reverting to numbers!

    Hi there

    I have an employee table with 3 fields and an employeeid,
    Firstname and emppassword. Employeeid is autonumber

    The problem is this firtsname and emppassword are text data type.
    However I noticed that in the table, the firstname field when filled with a name keeps reverting to a number, and even if I delete the record, the next name also reverts to the next number.

    I can’t seem to figure this out.

    Pls. could someone pls. tell me what is causing this and how to correct this from reverting

    Many Thanks in advance

  2. #2
    Join Date
    Jun 2004
    Posts
    92
    can you post your db so we can see it?

  3. #3
    Join Date
    Apr 2004
    Posts
    77

    re:'Text field keeps reverting to numbers!'

    Hi Sionus


    Thanks for ur reply to email.


    Attached is a copy of the dB as suggested , the emp taba nd the log on form

    Re my initiate message incase anybody missed it and needs to have better understanding:
    I have an employee table with 3 fields and an employeeid,
    Firstname and emppassword. Employeeid is autonumber

    The problem is this firtsname and emppassword are text data type.
    However I noticed that in the table, the firstname field when filled with a name keeps reverting to a number, and even if I delete the record, the next name also reverts to the next number.

    I can’t seem to figure this out.

    Pls. could someone pls. tell me what is causing this and how to correct this from reverting


    Many Thanks in advance.

Posting Permissions

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