[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 688
  • Last Modified:

setfocus in MS Access (VBA)

I am finding it quite difficult to do a simple task in VBA within Access. Here is the code I am trying:

Me.ChangeFlag.Visible = False
Me.histdate.setfocus

The error I get on the first line is "you can't hide a control that has the focus". So, when I switch the lines around and try this:
Me.histdate.setfocus
Me.ChangeFlag.Visible = False

I get "Access can't move the focus to the control HistDate". HistDate is a text box. Any ideas?

Glenn
0
tkecowboy
Asked:
tkecowboy
3 Solutions
 
snavebelacCommented:
Is Histdate disabled or locked ?  That would explain why the focus cannot move to it.

In your event to hide your first control, if you can move the focus to something else first - an enabled and unloacked control, it should work.

HTH

C
0
 
tkecowboyAuthor Commented:
well, I changed the code to look like this:

me.histdate.enabled = true
me.histdate.locked = false
Me.histdate.setfocus
Me.ChangeFlag.Visible = False

and I still get the error. In fact, I can't set the focus to any control on the form, which leads me to believe that there is sometihng in particular I must do within Access before setting focus on a control.
0
 
snavebelacCommented:
Are the controls part of a locked or disabled tab control or options group ?

The code you have should work just fine.  Is HistDate definitely a textbox ?

C
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
tkecowboyAuthor Commented:
The controls look like they are on a standard form. I inherited this app, but I'm pretty sure there's nothing wierd going on. histdate is definitely a textbox.
0
 
snavebelacCommented:
I have created a simple form here and use dthe code an it works just fine.  I did manage to generate the same error by trying to move the focus to an option button.

Can you check the properties of the texbox (if you have not done so already) to make sure there is nothing strange going on there.

This seems a little odd to me...

C
0
 
shanesuebsahakarnCommented:
Are you absolutely sure that histdate is the name of the *textbox* and not the field within the textbox? Check the textbox's Name property in the properties window.
0
 
Mr_AhmadCommented:

Hi

Make sure the initial properties on the controls are set to visible = true, locked = false, the code will work afte that, else it will give you that error message.

Reg
Zaf
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now