hi,
ive built a database on access 2000 and i want to make a few changes to it. one of my fields is called "subscription number"
and i want to make a validation on it.
when i enter the code
"If Len(Me!subscription_number & "" > 5" i get an error message saying that the field cant be found. how do i enter the field name onto this code? changing the field name would be too much trouble as i have used it already in many places....
i'm a beginner at this stuff so please help!!!!
tnx,
sades
ive built a database on access 2000 and i want to make a few changes to it. one of my fields is called "subscription number"
and i want to make a validation on it.
when i enter the code
"If Len(Me!subscription_number & "" > 5" i get an error message saying that the field cant be found. how do i enter the field name onto this code? changing the field name would be too much trouble as i have used it already in many places....
i'm a beginner at this stuff so please help!!!!
tnx,
sades