Setting focus to control after navigating to next record...

My Access DB has a main data entry form. There are so many fields on the form that I've added a vertical scroll bar. When my cursor is in a text box near the bottom of the form and click on the navigation button to go to the next record, that same text box still has focus and all of the text in the next record is selected. To view the top of the form, I now have to scroll up.

What I want to have happen is this:
I click on the navigation button to show the next record and focus is placed on a control at the top of the form which, in effect, will scroll the form up for me...

But I can't find a click event for the parts of the navigation buttons so I can set focus to the control I want for that event.... how to do this....?
Barry

Oct 4 '07 #1

Subscribe Post Reply

4926

missinglinq

3,532

Expert 2GB

Expand|Select|Wrap|Line Numbers

 Private Sub Form_Current()

  NameOfControlToGetFocus.SetFocus

End Sub

Welcome to TheScripts!

Linq ;0)>

Oct 4 '07 #2

bcwatson

Nevermind... I found out how...
I went to the OnCurrent event for the form and set the focus to the proper control there...

Oct 4 '07 #3

bcwatson

Nevermind... I found out how...
I went to the OnCurrent event for the form and set the focus to the proper control there...

Yup! That's how I did it... Thanks anyway... and thanks for the very quick reply! I'll be back here again I'm sure...

Barry

Oct 4 '07 #4

by: MLH | last post by:

A form named frmVehicleEntryForm has a number of textbox controls who's OnGotFocus property setting is an expression... =Change2Green() Change2Green() looks something like this... Dim MyControl...

Microsoft Access / VBA

Focus & Navigation Problem !

by: Prakash | last post by:

I have a continuous form in which I don't want to allow more than 255 rows. There is a field called sub_tran_no which is of the type "BYTE" & hence the restriction. My Problem: -----------...

Microsoft Access / VBA

Strange report error message - control must have focus

by: Stephen Poley | last post by:

I have a report which prints data from a parent table and two child tables (Contract and Kosten). Because it is a bit long, I suppress some fields which are often empty, based on methods found in...

Microsoft Access / VBA

Setting Focus to a Control - Web

by: Glenn T. Kitchen | last post by:

Hello All, Does anyone know how to set the focus to a textbox control on Page_Load? Thank you, Glenn

ASP.NET

Setting control focus with visual confirmation of same

by: LCAdeveloper | last post by:

Another newbie question I'm afraid. When I use the .Focus() or .Select() methods to set the initial control that has focus on a form, try as I might I cannot get the control to visually indicate...

Visual Basic .NET

Setting focus to a combobox in a grid

by: mfleet1973 | last post by:

Hello (again), Within my datagrid I add a control to the datagridtextboxcolumn when the underlying textbox receives focus as follows: Combobox1.Size = New...

Visual Basic .NET

Record Navigating Event on a Tab Control Page

by: JohnMOsborn | last post by:

I am designing an Access database that will use tab controls. Normally, you place different sets of fields on each page of the tab control – like Fields1-3 on Page 1, Fields 4-6 on Page 2, etc. In...

Microsoft Access / VBA

TabControl tab page requires focus to update?

by: Redback | last post by:

Im using VS 2005. I have a form with a tab control. I have text boxes which are bound to a binding source, which is bound to a dataset. I have a button on the form that allows the user to add...

Visual Basic .NET

Setting focus in a tab control in a nested subform when main form record changes

by: angi35 | last post by:

I hope this is an easy question for someone out there. In Access 2000…I have a MainForm with a tab control (MAIN TABS) with 7 tabs. Within each tab is a SubForm. Within each SubForm is a tab...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Setting focus to control after navigating to next record...

Similar topics