Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Error about Field type/size

Discussion in 'Information Technology' started by langirl77, Jul 28, 2006.

  1. langirl77

    langirl77
    Expand Collapse
    Guest

    Hi,

    I am getting an error when you go to any record in my database.
    Unfortunately I am not the only one who has access to make changes but I am
    the only one "supposed" to be doing it. I didn't make any changes so someone
    did and I don't know how to figure out what it was. The error I get is 'the
    value you entered isn't valid for this field.' It doesn't tell me what field
    so how to I figure that out. The strange thing is that when I opened Access
    help and then went to a new record to generate the error it doesn't happen.
    So with help open I don't get the error. I can still do everything I need to
    with the database but when using it I get this error. Any advice???
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    It is almost certain that someone has altered the bound column of a lookup
    field. Open the form in design view and ensure that all the bound columns
    are set as you designed them to.

    The normal reason you get this error (when someone has been messing about
    with the design) is

    Lookup
    Column widths 0;2;2

    Column1 [FieldID] Auto number
    Column1 [FieldText] Text field
    Column1 [FieldText] Text field

    If the bound column has been change from 1 to (for example) 2 or 3 you will
    have text being stored in a number field – but as col 1 has a width of 0 you
    wouldn’t know this.

    After you have sorted it out you really should look at restricting access to
    anyone who doesn’t need it and know what they are doing.

    Hope this helps

    --
    Wayne
    Manchester, England.



    "langirl77" wrote:

    > Hi,
    >
    > I am getting an error when you go to any record in my database.
    > Unfortunately I am not the only one who has access to make changes but I am
    > the only one "supposed" to be doing it. I didn't make any changes so someone
    > did and I don't know how to figure out what it was. The error I get is 'the
    > value you entered isn't valid for this field.' It doesn't tell me what field
    > so how to I figure that out. The strange thing is that when I opened Access
    > help and then went to a new record to generate the error it doesn't happen.
    > So with help open I don't get the error. I can still do everything I need to
    > with the database but when using it I get this error. Any advice???
     

Share This Page