textbox is skipped when tabbing

E

EVPLS

Hi,

in an order entry form, I have 5 textboxes and a subform whose TabStop
property is True (more textboxes are present which users shall not tamper
with, TabStop False):

cboCustomer: AutoTab False, TabStop True, TabIndex 0
cboReference: AutoTab False, TabStop True, TabIndex 1
txtRefDate: AutoTab False, TabStop True, TabIndex 2 (date set by calendar
popup form)
txtRefNote: AutoTab False, TabStop True, TabIndex 3
txtContact: AutoTab False, TabStop True, TabIndex 4
txtComment: AutoTab False, TabStop True, TabIndex 5
sfrOrdersItems; TabStop True, TabIndex 6

Using TAB key, the sequence works fine until txtComment should be entered,
Aceess (2000) jumps straight from txtContact to the subform. Same happens, as
a matter of fact, if you mouse-click into txtComment.

I double-checked txtComment properties and either I olverlook the obvious or
else. These are the txtComment props:

EventProcPrefix txtRemarks
Name txtRemarks
ControlType 109
ControlSource
Format
ConditionalFormat Null
DecimalPlaces 255
InputMask
DefaultValue
ValidationRule
ValidationText
StatusBarText
EnterKeyBehavior True
AllowAutoCorrect True
Visible True
DisplayWhen 0
Vertical False
Enabled True
Locked False
FilterLookup 1
AutoTab False
TabStop True
TabIndex 5
ScrollBars 0
CanGrow False
CanShrink False
Left 4536
Top 851
Width 8505
Height 284
BackStyle 1
BackColor -2147483643
SpecialEffect 0
BorderStyle 1
OldBorderStyle 1
BorderColor 0
BorderWidth 0
BorderLineStyle 0
ForeColor 0
FontName Arial
FontSize 10
FontWeight 400
FontItalic False
FontUnderline False
TextFontCharSet 0
TextAlign 0
FontBold 0
ShortcutMenuBar
ControlTipText
HelpContextId 0
ColumnWidth -1
ColumnOrder 0
ColumnHidden False
Section 0
Tag
Text
InSelection False
SelText
SelStart 0
SelLength 0
BeforeUpdate
AfterUpdate
OnChange
OnEnter
OnExit
OnGotFocus
OnLostFocus
OnClick
OnDblClick
OnMouseDown
OnMouseMove
OnMouseUp
OnKeyDown
OnKeyUp
OnKeyPress
LeftMargin 57
TopMargin 0
RightMargin 57
BottomMargin 0
LineSpacing 0
IsHyperlink False

Has anyone got an idea? Oh yes, I did compact and repair.

Thanks a lot in advance for any suggestions.
 
R

Rick Brandt

EVPLS said:
Hi,

in an order entry form, I have 5 textboxes and a subform whose TabStop
property is True (more textboxes are present which users shall not
tamper with, TabStop False):

cboCustomer: AutoTab False, TabStop True, TabIndex 0
cboReference: AutoTab False, TabStop True, TabIndex 1
txtRefDate: AutoTab False, TabStop True, TabIndex 2 (date set by
calendar popup form)
txtRefNote: AutoTab False, TabStop True, TabIndex 3
txtContact: AutoTab False, TabStop True, TabIndex 4
txtComment: AutoTab False, TabStop True, TabIndex 5
sfrOrdersItems; TabStop True, TabIndex 6

Using TAB key, the sequence works fine until txtComment should be
entered, Aceess (2000) jumps straight from txtContact to the subform.
Same happens, as a matter of fact, if you mouse-click into txtComment.
Click to expand...

Is txtComment by any chance in the form header or footer? The normal tab
sequence does not automatically jump between form sections. Same would be
true if the control were on a TabControl page.
 
E

EVPLS

Hello, Rick,

nope, neither in header nor footer, nor on a TabControl page. All of the
textboxes and lso the subform mentioned in my original post are in the same
section, Detail. This is what gets me puzzled.

Thanks for any advice.
 
R

Rick Brandt

EVPLS said:
Hello, Rick,

nope, neither in header nor footer, nor on a TabControl page. All of
the textboxes and lso the subform mentioned in my original post are
in the same section, Detail. This is what gets me puzzled.

Thanks for any advice.
Click to expand...

Any code in the OnExit or LostFocus event of the txtContact control?
 
C

charles

No.

The text is being pasted directly into the table.
There are no forms or queries. Its a brand new database.

Charles W
 
E

EVPLS

Hello Rick,

could one be sooooo stupid? You got it, txtContact's OnExit procedure
includes a SetFocus instruction telling Access to move to the subform. Stupid
machine, does exactly as told (grin).

Thanks a lot for pointing me to the solution. I removed the instruction and
it works.
 
Top