Tab in text box

[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

 

[Dirk Goldgar]

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?

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".

 

[Phillip]

Thanks Dirk, that did fix my probem.
Phil

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)