I have several fields with text boxes and input masks. When a user clicks in these fields, it puts them in whatever position in the text box they click in. If they click to the far right, it takes them to the right position and doesn't let them type the entire date, formula, etc.
Any way to set the text box so that no matter where they click it automatically starts in the first position?
I have below code for maximum 3 criteria dynamic search:
Code:
Private Sub SearchFor_Change()
Dim strWhere As String
Dim Criteria As String
Dim i As Integer
Dim A
Dim strAdd As String
[code]...
There is a problem, since I put the code in a textbox's on change event. then in case i want to revise the first two criteria, the cursor will automatically fleets to the end of the text, I want to know how to keep the position of the cursor?
I am using an unbound textbox at the top of my form for filtering purposes. The user types in a string and hits "Tab" which kicks of the filter which is defined in the AfterUpdate property. I want the focus to return to the same textbox and position the curosor after the last character. I am trying to use SelStart but not having success.
Code:
Me.Filter = "COURSE_NAME Like '*" & Me.txtFilter & "*'"
Me.FilterOn = True
txtFilter.SetFocus
txtFilter.SelStart = txtFilter.SelLength
Access 2003 Form
Can i move the blinking cursor to the end of field? I set in the options but it goes to the start of the field. and wants to overwrite the default text. I would like it to start at the end of the default text.
Can it be done with code?
Thankyou
Hi
ive got a form that has several textboxes. The cursor in all textboxes appears on the left hand side (which is good), but one field shows the cursor on the right side??!!! how do i change this, i want the cursor to be on the left hand side like the rest?
cheers
I'm trying to ensure that each time a new record is opened in a form, that the cursor is positioned in the first control/field... I have this throughout most of my application but not in a few individual forms.
I know I've done something in the past to ensure that this happens, but I can't remember what it was...
Thanks,
Peter
I have a text box which i use as a "search box"
I type in characters and my data sheet at the bottom will display all matches
What i want to happen is for the cursor to stay on the same text (search) box after hitting enter.
I recently found a neat little module which allows you to duplicate a right click & bring up pop up menu ( say by left clicking on a field). I find this very good for creating a nice little menu system in which I can reproduce the nice features of Access menus (I'm using Access 2002) but with a lot more flexibility.
So, I have a line of labels across the top of the form which are my top level menu items - when I click or mouse over these I want to have the pop up menu appear directly under the label. I can position the pop up menu manually by SetCursorPos(x,Y) but as my forms are Pop Up and can move this has proved to be a pain.
What I am after is something that will allow me to work out the coordinates of the left bottom of the label and then position the cursor there then drop the menu. The difficulty I'm having is converting or understanding the position of the label (me.label1.left etc) and relating that to what SetCursorPos needs.
On main form cursor working is goods as per default. But after come to in Subform its shown the cursor position in the last filed. So every new record is shown as the same last field. How to do this cursor position will be change in subform as per default?? and every new record its need to show as per default TabIndex "0".
I have checked my Tab Index & Order Settings also it is good. But its shown as last filed in subform
I have attached the Screen shot.
Is there an automatic way of moving the cursor when an outlook email is opened using a VBA event??
Right had a look and haven't managed to google this yet but the background is as follows
I have some code that puts a recordset of people's email into outlook and leaves users with the outlook message open ready for them to append anything they want to the message body.
At the moment the cursor flashes at the very start of the message and users need to scroll down with keys or the mouse to the end before they can add additional text.
I want to automatically move the cursor to the end of the outlook email message opened using a VBA event?
I have several comboxes where I'm using date/time input masks. When I go to enter data in the field the cursor is situated at the right end of the box. I have to backspace to the beginning of the field to enter the data. How do I position the cursor to the beginning (left side) of the field?
View 3 Replies View Relatedhello my dear friends...
Few days ago I found some VB code which autometically move the cursor to the left of the field (with input mask) in a form to begin with... I mean whereever you click the cursor in the field it autometically comes in the beginning (left)...
I remember i have tried it with a sample form... but now today i can't find it...
I think i lost it...
Today i have searched the forum for this but coudn't retrive it...
Could someone find me out where it is??
Thanks in advance for your help
Hi,
I have a Category form with a products sub form so that upon selecting a category it displays the products for that category in the sub form.What i want to do is have a pop up box so that when a person clicks on the product name in the sub form it pops up saying you need to open the products form to enter new products.
I have seen this before on this forum but can't find it know that i need it. (typical :rolleyes: )
Thanks
Dean
I would like a date field I have set up to auto populate the current date when I click on another field to enter information.. how would I do that?
View 5 Replies View RelatedHello all,
I have a text box that allows users to type a letter to a customer with a listbox next to it. The listbox is filled with data such as the customer's name, address, etc.... When the user double clicks an item from the list box, it should insert the appropriate data into the text box.
The problem is, is there a way to determine the current cursor location in the textbox so I know where to add the data?
For example, the cursor location has been determined before the text box lost the focus and now i am inserting the apporpriate data:
Textbox = left(TextBox, CursorLocation) & DataFromListbox & right(textbox,len(textbox) - CursorLocation)
Thanks for all your help.
Is it possible to force the cursor to move to the start of a text box when it gets the focus? (I suppose what I am really asking here is, is it possible to force a 'Home' key event?)
There is a text entry box, which when people put the cursor into it, it sometimes sits part the way in, consequently the operator could end up trying to type in more information than there is available space. I know that education might go along way here, but you just can't teach some people.
Tim
I have a form. On the form is a pull down box. When the user clicks a submit button on the form, it displays a message box if the name field is not filled out. I want to make it so that after the user clicks 'ok' on the message box, the cursor goes to the name text box so it makes it easier for the user to input his/her name. I would appreciate if some one could help me on this matter. Thank you.
View 4 Replies View RelatedI have a form with text boxes and after I click on the text box, the field gets grayed out. I can still read my text but I would rather it have it stay white.
MS Access 2010
I made an On Change Procedure on a textbox, so everytime I input a character, it will trigger the Me.Requery.
However, after that the event, the mouse cursor moved to the beginning of other field. I want it to stay at the end of the textbox so I can enter a full word, how do I do that?
Code:
Private Sub Text73_Change()
ProjectSearch = Me.Text73
Me.Filter = "[Project Name] Like " & Chr(34) & ProjectSearch & "*" & Chr(34)
Me.FilterOn=True
Me.Requery
End Sub
Hello,
I have searched the forum for the answer but cannot seem to find exactly what I am looking for.
I have a table with the PK auto assigned. Currently have about 150 records in it.
I would like to add a prefix to the Auto Assigned ID for all current and future records for an example if the record is 1 I want it to say GEN-1, GEN-2 etc..
I found this code however I cannot seem to integrate it into what I am trying to do.
Add a field that holds the date a record was added to the table. When you want to display a formatted autonumber field, use an expression.
Format(DateCreated,"yy") & "-" & Format(YourAutonumber,"000000")
This will produce something like -
03-000145
Thanks!
Fen How
Hey Gang,
I haven't looked in the forum yet, this is just an idea that popped into the air.
Is there a way to auto insert a text of my choice into a field on a form.
Example:
I am constantly typing "No Supervisor Signature on Weldment" along with a few other phrases. It is not as simple as copy and past, if it was that easy I would not be asking the group. I am in and out of access 200 times a day. and I wanted to know if I can assign a "HotKey" to auto insert these phrases that I use.
Thanks in advance. :D
PuJo
Hi,
I need the text in the field to allow both lower and upper case but when the user enters "i" (only 1) it changes to "I" , "ii" works just fine.
How can I stop this??
I guess I could write an event code like:
Dim LowerCase, UpperCase
UpperCase = Me![FieldName]
LowerCase = LCase(UpperCase)
If Me.[FieldName].Value = "i" Then
Me![FieldName].Value = LowerCase
Else...
Any other ideas????
Thanks
Paul
I've noticed that Access has a few default "fixes" for text in a field. For instance, if I type "aBBB" then tab to the next field (whether in a table, a form or anywhere else), Access will autocorrect that to "Abbb". This is really helpful if I leave caps lock on and am trying to type names, such as "aLEX" being changed to "Alex".
Is there a way to make it auto capitalize everything in the field? I don't want to turn such a thing on for every field, just for some select fields. Perhaps some sort of self-correcting mask, whatever you would call something like that, that I could apply to various fields.
I have a form with a text box named HRName.
When I populate a combo box named BusOrgCode, I want to auto-populate the HRName box with the name that corresponds with the Bus Org Code. I get a run time error "2001." Help!
Here's my code:
+++
Private Sub BusOrgCode_AfterUpdate()
Dim strFilter As String
' Evaluate filter before it's passed to DLookup function.
strFilter = "BusOrgCode = " & Me!BusOrgCode
' Look up HR Partner Name and assign it to HRName control.
Me!HRName = DLookup("HRName", "HR by Bus Org Code", strFilter)
Exit_BusOrgCode_AfterUpdate:
Exit Sub
End Sub
+++
I've created a Form based on a Query.
The Form is in table mode (multiple forms).
I've added a new text box.
Each time I enter anth in the text box of a record,
all the other relative text boxes in all records of form fill with the same.
Why?
I want to enter different data.
Plz help. Tomorrow I should have the DB ready!
I am trying to auto populate a text box when i click on the button to add a new record. This is the code for the addnewsequence button.
Private Sub addnewsequence_Click()
On Error GoTo Err_addnewsequence_Click
DoCmd.GoToRecord , , acNewRec
Exit_addnewsequence_Click:
Exit Sub
Err_addnewsequence_Click:
MsgBox Err.Description
Resume Exit_addnewsequence_Click
End Sub
In this form is a text box called degree name that is link from the table degree. It autopopulates with the degree upon the sequence form first opening button clears the text box when i click add new sequence
any help greatly appreciated...
Thank you