Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / May 2008

Tip: Looking for answers? Try searching our database.

textbox is skipped when tabbing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
EVPLS - 25 May 2008 10:33 GMT
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.
Rick Brandt - 25 May 2008 13:06 GMT
> Hi,
>
[quoted text clipped - 14 lines]
> entered, Aceess (2000) jumps straight from txtContact to the subform.
> Same happens, as a matter of fact, if you mouse-click into txtComment.

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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

EVPLS - 25 May 2008 15:36 GMT
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.

> > Hi,
> >
[quoted text clipped - 18 lines]
> sequence does not automatically jump between form sections.  Same would be
> true if the control were on a TabControl page.
Rick Brandt - 25 May 2008 15:44 GMT
> Hello, Rick,
>
[quoted text clipped - 3 lines]
>
> Thanks for any advice.

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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

charles@home.com - 25 May 2008 21:58 GMT
No.

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

Charles W

>> Hello, Rick,
>>
[quoted text clipped - 5 lines]
>
> Any code in the OnExit or LostFocus event of the txtContact control?
EVPLS - 26 May 2008 05:55 GMT
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.

> > Hello, Rick,
> >
[quoted text clipped - 5 lines]
>
> Any code in the OnExit or LostFocus event of the txtContact control?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.