access2003 form field cursor - microsoft.public.access.forms

I have a drop down field to select an invoice to print, but if the field has data in it already from a previous selection The cursor appears as just a line at the end of the field. How can I make the cursor select the whole field without the user needing to click and drag?? I thought I remembered doing this before, by a property setting, but I can find it. does someone out there know how to do this??

Why in the world are you trying to drag the value in a combo box? -- Dave Hargis, Microsoft Access MVP "Programmer - wannaB" wrote: > I have a drop down field to select an invoice to print, but if the field has > data in it already from a previous selection The cursor appears as just a > line at the end of the field. How can I make the cursor select the whole > field without the user needing to click and drag?? > > I thought I remembered doing this before, by a property setting, but I can > find it. does someone out there know how to do this??

You misunderstood my question; by click and drag I am saying that they need to click the mouse in the combo box and drag across the field to highlight the data already there,and then either remove it or begin typing to replace what they hightlighted and get there new selection. I have already added Me!<formname>.dropdown to on click. Now I would like for the curson to select the whole field when the user clicks the field. Can I add something like SELECTALL to the on click, or is there a form or field param that can be set to select entire field??? "Klatuu" wrote: > Why in the world are you trying to drag the value in a combo box? > -- > Dave Hargis, Microsoft Access MVP > > > "Programmer - wannaB" wrote: > > > I have a drop down field to select an invoice to print, but if the field has > > data in it already from a previous selection The cursor appears as just a > > line at the end of the field. How can I make the cursor select the whole > > field without the user needing to click and drag?? > > > > I thought I remembered doing this before, by a property setting, but I can > > find it. does someone out there know how to do this??

Okay, sorry I misunderstood. You can use the SelStart and SelLength properties to do this. Use the combo's Got Focus event With Me.MyCombo .SelStart = 0 .SelLength = Len(Me.MyCombo) End With -- Dave Hargis, Microsoft Access MVP "Programmer - wannaB" wrote: > You misunderstood my question; > by click and drag I am saying that they need to click the mouse in the combo > box and drag across the field to highlight the data already there,and then > either remove it or begin typing to replace what they hightlighted and get > there new selection. > I have already added Me!<formname>.dropdown > to on click. Now I would like for the curson to select the whole field > when the user clicks the field. Can I add something like SELECTALL to the > on click, or is there a form or field param that can be set to select entire > field??? > > "Klatuu" wrote: > > > Why in the world are you trying to drag the value in a combo box? > > -- > > Dave Hargis, Microsoft Access MVP > > > > > > "Programmer - wannaB" wrote: > > > > > I have a drop down field to select an invoice to print, but if the field has > > > data in it already from a previous selection The cursor appears as just a > > > line at the end of the field. How can I make the cursor select the whole > > > field without the user needing to click and drag?? > > > > > > I thought I remembered doing this before, by a property setting, but I can > > > find it. does someone out there know how to do this??

Thanks that helped. All I really needed was Me.MyCombo.SelStart = 0 With that when they click at the end of the field it will highlight everything to the cursor. it works great thanks. ============================ "Klatuu" wrote: > Okay, sorry I misunderstood. > > You can use the SelStart and SelLength properties to do this. Use the > combo's Got Focus event > > With Me.MyCombo > .SelStart = 0 > .SelLength = Len(Me.MyCombo) > End With > > -- > Dave Hargis, Microsoft Access MVP > > > "Programmer - wannaB" wrote: > > > You misunderstood my question; > > by click and drag I am saying that they need to click the mouse in the combo > > box and drag across the field to highlight the data already there,and then > > either remove it or begin typing to replace what they hightlighted and get > > there new selection. > > I have already added Me!<formname>.dropdown > > to on click. Now I would like for the curson to select the whole field > > when the user clicks the field. Can I add something like SELECTALL to the > > on click, or is there a form or field param that can be set to select entire > > field??? > > > > "Klatuu" wrote: > > > > > Why in the world are you trying to drag the value in a combo box? > > > -- > > > Dave Hargis, Microsoft Access MVP > > > > > > > > > "Programmer - wannaB" wrote: > > > > > > > I have a drop down field to select an invoice to print, but if the field has > > > > data in it already from a previous selection The cursor appears as just a > > > > line at the end of the field. How can I make the cursor select the whole > > > > field without the user needing to click and drag?? > > > > > > > > I thought I remembered doing this before, by a property setting, but I can > > > > find it. does someone out there know how to do this??

Similiar Articles:

Cursor position with input mask - microsoft.public.access ...
I have an Access 2003 form where several textboxes have input masks. I want the cursor to always position at the beginning of the field when the user ...

Scan Barcode and tab key - microsoft.public.access
Using Access 2003, I have a data entry form that will be using with wireless barcode ... to set these 3 fields with an automatically moving cursor to the next field ...

Required Fields for New Form/Record - microsoft.public.access ...
I created a form where all fields are required ... initial entry of a new form. If > > the > > user puts their cursor in ... Access 2003: Adding Form Records - Lesson 10 When ...

Subform Field Vertical Scroll - microsoft.public.access.forms ...
... using Access 2003, Windows XP. I have a subform with a field ... access.forms ... Hello, using Access 2003, Windows XP. I have a subform with a field ... Memo Field Cursor ...

Naming a formfield - microsoft.public.word.vba.general
Create A Form In Word - Microsoft Word 2010 Tutorials Let’s insert a form field for Name. Place the cursor in ... form in my Access 2003 database... ... Input Form Field ...

How do I set the focus for a field after new (blank) record ...
How can I make the cursor go to the first > field on the form like it does ... Access: Set the focus on the first field in a form whenever a record is viewed in Access 2003 ...

How can I use VBA to insert a char at the current text insertion ...
... Windows Character Map within my Access 2003 ... active text control on my main form - at the current position of the text cursor. ... inserting text form field in a text box ...

Command Button to Sort and Filter by Selection - microsoft.public ...
I am using Access 2003 and I am NOT familiar with ... possible to create a command button on a form ... much on telepathy *smile* but on whatever field she places her cursor ...

Need pop-up form/report to populate based on current record ...
I'm using Access 2003, and the Help utility isn't ... different one, when you close the Form, or when you move the cursor ... Pop up selection to form field - microsoft ...

"Enter" key moving to next field - microsoft.public ...
Using Access 2003, what sort of command should ... I would like to set these 3 fields with an automatically moving cursor to the ... Set up form fields to that Tab can be used to ...

MS-Access 2003 Cursor Control: Microsoft Access 2003, cursor ...
I'm programming a telephone edit in a MS-Access 2003 form field using VBA. My operating system is XP/Pro. Whenever invalid data is detected I display a MsgBox from ...

MS Access: Set the focus on the first field in a subform whenever ...
In Access 2003/XP/2000/97, I have a control ... does not go directly to the first field of data entry. How can I get the cursor to move to the first field on the form?

Microsoft Access Form Behaviors - Position the Cursor in a Text ...
Moving the Cursor To The End Of A Microsoft Access Textbox: In Microsoft Access ... point when pressing the ENTER, TAB, or arrow keys to move from field to field on forms ...

Form Trick: Pre-load the Cursor in a Text Box
This tutorial shows how to have the cursor preloaded into a form field when the page loads.

How do I have the cursor placed in a text field on page load ...
How do I have the cursor placed in a text field on page load? ... Now, there are two parts to having a text field (or any HTML form entity ...

7/25/2012 9:02:59 PM