I have a subform in datasheet veiw and need to remain on the input field / record if null or zero is entered, the problem ive got is that if i press enter the control moves to next field and if i press up/down arrow the control moved to same field but next/previous record and even if the mouse is used to select another record the control should remain on that record and field.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Remain on field if null or 0 entered in datasheet view 1
- Thread starter ftook
- Start date
-
1
- #2
TheAceMan1
Programmer
How are ya ftook . . .
In the [blue]On Exit[/blue] event of the control try:
See Ya! . . . . . .
Be sure to see FAQ219-2884:
In the [blue]On Exit[/blue] event of the control try:
Code:
[blue] If IsNull(Me!CoName) Then Cancel = True[/blue]Be sure to see FAQ219-2884:
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question