Search Result

yptrumpet · Jan 3 '12, 12:59 AM

Hi all. This is a bit of an aesthetic problem.

I have a form containing two subforms and two comboboxes. When the forms first load, the first combobox receives focus. I'd like the text input cursor to be placed at the end of the text whenever the bombobox receives focus. Trolling Bytes.com tells me that the following code works for most people, so I put it in the cboEmpID_AfterU pdate event procedure.

Me.cboEmpID.Sel Start = Len(Nz(Me.cboEm pID,

...

gnawoncents · Feb 4 '11, 07:04 PM

Greetings,

I have a datasheet, created through VBA, and I am trying to automate setting the column widths to Best Fit. Currently I loop through the controls using the code below

Code:

    'Set width of columns to best fit data
    Dim ctl As Control
    For Each ctl In Forms![Form1].Controls
        If (ctl.ControlType = acTextBox) Then
            ctl.SetFocus
            Call TBBestFit

...

Veeves · Sep 16 '09, 09:13 PM

I have an unbound field on a form. In the onClick event I have code to populate a text field. I first setFocus to it and enable it. Both of these actions work. But when my code reaches the the line whete I set the textfieldname.t ext to a value, I get an error: You can`t reference a property or method unless the control has focus.

My code is:

Code:

txtFileName.Enabled = True
txtFileName.Visible = True
txtFileName.SetFocus

...

FelixS · Aug 17 '09, 06:42 PM

Situation: A form is opened containing subform, contents of subform is changing dynamically on form Open. I would like to have the first text box of subform under focus. Before opening, the name of the control is assigned to pubFirstControl variable.
So far I could not find the way to solve this problem.
Any hints?

Search Result

placing text insertion point at the end of combobox contents

How do I set the Focus to a Popup Dialog?

SetFocus does not work in Access form

How to set focus to text box on subform if name of the control if public var.