Tab in text box

  • Thread starter Thread starter Phillip
  • Start date Start date
P

Phillip

Hi,
I have a form with 11 text boxes. If I tab, tab, tab.... through the boxes
after the last box my data in all the boxes goes blank. Can someone tell me
why and how to fix this problem?
Thanks
Phil
 
Phillip said:
Hi,
I have a form with 11 text boxes. If I tab, tab, tab.... through the
boxes
after the last box my data in all the boxes goes blank. Can someone tell
me
why and how to fix this problem?
Click to expand...


It sounds to me like you have tabbed into a new record. Normally, when you
tab out of the last control on a form, Access will automatically move the
form to the next record, which may be the "new record" (blank) if you were
on the form's last record already. If you don't want this to happen, you
can set the form's Cycle property (on the Other tab of the form's property
sheet in design view) to "Current Record", rather than "All Records".
 
Thanks Dirk, that did fix my probem.
Phil

Dirk Goldgar said:
It sounds to me like you have tabbed into a new record. Normally, when you
tab out of the last control on a form, Access will automatically move the
form to the next record, which may be the "new record" (blank) if you were
on the form's last record already. If you don't want this to happen, you
can set the form's Cycle property (on the Other tab of the form's property
sheet in design view) to "Current Record", rather than "All Records".

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)
Click to expand...
 
Back
Top