Error Message: The Value you entered isn't valid for this field

[MySki]

Good afternoon,

I have a question I'm hoping someone can help me with. I have an access database that has already been created. I am using a form as a data entry screen to enter employee information. I have created a drop=down menu from which the user can select various application systems that the user has acces to. the drop down pulls from and populates a separate table.

Herin lies my problem. i have received updated information from the network that I am trying to import into my application system table. I cleared the existing data from the table and imported the new data. Now, when I run the form, I get the following error message:

The value entered isn't valid for this field. For example, you may have entered text in a numberic field or a number that is bigger than the field size setting permits. the field size is set at 100, so this is not the problem.

Does anyone have any suggestions?

Thanks in advance,

MySki

 

[Rolliee]

can you write a command button to msgbox all of the field types - both the source and the final recordsets?

rollie@bwsys.net

 

[MySki]

Not sure what you mean by this..an you expand a little??

Thanks!

 

[Rolliee]

Place a command button on the form. In the OnClick event of the button use this code.

for i = 0 to number of fields - 1 ' this is a number say 10
msgbox "This is field number " & str(i) & me.fields(i)
next i

This should loop you through the fields and tell you their values. Then you could also add a varType( ...) or TypeVar(...) I always do it wrong and have to reverse. The ... is the "Me.fields(i)" You can look at all the properties. This is not for a user, only as you develop the mbd


rollie@bwsys.net

 

[MySki]

Thanks..I'll give it a try and see what happens.