Database problem

  mammak 22:33 26 Apr 05

Hi i am ashamed to say i have a problem in access database i need to in one field put a validation rule in and a validition text but alas it wont work i need to put, Only type "DVD OR VHS" sorry its so lame but need to keep you on your toes bright peeps, again sorry kindest regards Mammak.

  harps1h 23:59 26 Apr 05

you don't necesarily need to put in a validation rule but if you did it would read "dvd" OR "vhs"- the validation text could read please enter format. in the row required make it yes

go into the look up tab and do this

1/ make it a combo box

2/row source type should be set at value list

3/row source is then "dvd";"vhs"

try that and see what happens

  harps1h 23:32 29 Apr 05

did you get sorted out?

  mammak 21:32 04 May 05

Thanks harps1h i did,validation text "DVD OR "VHS" validation rule MUST BE ONE OF THE FOLLOWING, thanks again sorry i took so long to get back but college is real tough at the moment.regards Mammak.

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…