Set the Controls to the Heart of the Sun - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Set the Controls to the Heart of the Sun

Colin Eastaugh

5 months ago

Sorry, I couldn't resist using a Pink Floyd title. More accurately, and less pretentiously, I should have called this post the 'Cursor loses interest'.

I have a continuous form, when I action a routine which includes a couple of sub-routines, the cursor disappears, it only comes back to life when I use the mouse to hover over the label "SBox" in the form header and then press click, I need to use "SBox" when the routine has been actioned.

The sub-routines consists of disabling setwarnings, tables are deleted, spreadsheets are uploaded, an append query is run, setwarnings is switched back on.

I've used:

DoCmd.GoToControl "SBox"
Forms!frmSum!SBox.SetFocus

But no joy.

Can anyone help?

	Donald Blackwell @Reply 5 months ago
Have you tried SelStart? DoCmd.GoToControl "SBox" SBox.SelStart = 0 (optionally) SBox.SelLength = len(SBox) Should highlight anyting in the field if there is anything

	Colin Eastaugh OP @Reply 5 months ago
Donald - many thanks for replying so quickly. SelStart doesn't seem to help but thanks for the suggestion. "SBox" is a label. Once the routine alluded to above has been run if I try using the keyboard I get the sound which indicates that I can't use the keyboard until I have clicked on the mouse. Weird - Colin

	Donald Blackwell @Reply 5 months ago
Another shot in the dark... Add: SBox_Click Before the closing End Sub or End Function declarations in your other routine(s)?

	Colin Eastaugh OP @Reply 4 months ago
Thanks for the reply. Still coming up blank. It is weird. DoCmd.GoToControl works in some routines and not others. I'm going to leave it for a few days and then come back with a fresh mind, currently my mind seems obscured by clouds.

	Kevin Robertson @Reply 4 months ago
You can't set the focus to a Label.

	Colin Eastaugh OP @Reply 4 months ago
Many thanks for the response. Can't set the focus to a label, ah, that is a problem if DoCmd.GoToControl isn't working, or putting it into Pink Floyd language, that is another brick in the wall. Sorry, couldn't resist. Thanks again.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View