Control+Enter issue

[gblack]

OK I'm setting up a simple application for a user who doesn't listen, when you tell them they can't do this...but in Access if you hit control+Enter (whilst doing data entry), it allows you to put data in the same cell essentially tabbing below the previously entered data.

This is annoying because it makes it tough to run queries if some random set of data is sitting below the data that you actually see in the field.

So my questions are:

1) Is there anyway to easily deal with data entered in this way?

OR

2) Is there a way to prevent data entry in this manner (other than asking the user to stop doing it?

If the answer is yes to either (or Both) of these questions...please elaborate. I'm really not liking Ctl+Enter. I have no idea why access allows this as a valid way to enter data!!!

Thanks,
Gary

 

[FoFa]

CNTL+ENTER is used mostly in text boxes to add a new line when ENTER tabs to the next box.
Years ago I read something about catching things like this, using the KeyPress, KeyDown events, and checking the ascii characters. You may try to search on those and see if you can find something.

 

[pdx_man]

On the KeyPress event for the control, have:

If KeyAscii = 10 Then DoCmd.CancelEvent


HTH

 

[gblack]

Thanks!