Search results

Okay thanks, the validation rule worked and I had thought of it but I had put (Len([fieldname])>=3 And Len([fieldname])=<6) and Access didn't accept that, I did it your way and it works perfect! Thanks a lot guys.

No, nothing get's handed in, this is just the exam the pupils from last year got and the teacher put it online for us, so we can get a look at what kind of questions we can expect, none of those questions will ever get evaluated, I just wanted to make sure I was able to do every question on that...

Well, I have no idea, I'm just studying for an Access exam tomorrow and the teacher posted a 'test exam' and that was the one question I was having trouble with.

I'm actually not in any kind of form, i'm just in the Table Design View. I'm inputting the destination codes straight into the table and that's where I want the limits to work. I'm sorry if I was unclear. Thomas

I have a database and one of the fields is a destination code, now I need to be able to say that when someone enters a destination code, this code has to be at least 3 characters long and can be no more than 6 characters long. I thought I would be able to do this by doing something in the...