L
louonline
Hello,
My thanks to all those who helped me with my project.
I'm now nearly finished and trying to put some cosmetic touches on it
to make it feel more "professional".
On my invoice form I have a textbox named "SALES_ID" with an field
length of 1.
The validation rule is set to "W" Or "P" Or "A" Or Is Null and the
validation text is "You must enter "W", "P" , "A" Or leave empty"
This works fine.
What I would like to see happen when the user enters an invalid
letter and the curser goes back to the "SALES_ID" textbox (after
clicking OK on the validation text message) is for the invalid letter
to be automatically deleted/cleared so the user just has to enter a
valid letter as opposed to having to backspace/delete the invalid
letter manually and then enter a correct one (or leave it blank).
As I said this is purely for cosmetic eloquence and I can live
without it but it would add a professional touch if it can be done.
I have tried a couple of things to accomplish the above but none of
them worked
I'll probably look a fool when you tell me that this is a standard
function in Access but as is said, `you'll never know if you don't
ask!'
Regards,
Lou
My thanks to all those who helped me with my project.
I'm now nearly finished and trying to put some cosmetic touches on it
to make it feel more "professional".
On my invoice form I have a textbox named "SALES_ID" with an field
length of 1.
The validation rule is set to "W" Or "P" Or "A" Or Is Null and the
validation text is "You must enter "W", "P" , "A" Or leave empty"
This works fine.
What I would like to see happen when the user enters an invalid
letter and the curser goes back to the "SALES_ID" textbox (after
clicking OK on the validation text message) is for the invalid letter
to be automatically deleted/cleared so the user just has to enter a
valid letter as opposed to having to backspace/delete the invalid
letter manually and then enter a correct one (or leave it blank).
As I said this is purely for cosmetic eloquence and I can live
without it but it would add a professional touch if it can be done.
I have tried a couple of things to accomplish the above but none of
them worked
I'll probably look a fool when you tell me that this is a standard
function in Access but as is said, `you'll never know if you don't
ask!'
Regards,
Lou