Tagged Questions
3
votes
2answers
2k views
Access report “Can Grow” property needs to effect neighboring controls
I have a report with a bunch of controls in the Detail section.
I am working off a word document that was given to me as a sample and I recreated it in access almost perfectly. What I need now is a ...
2
votes
2answers
898 views
Update textbox during typing
In Access, I have a form in which there are three textboxes.
I am trying to update a textbox called tbxCombinedName with a combination of both:
textbox tbxLastName (person's Last Name)
textbox ...
1
vote
1answer
110 views
Cannot reference to a form control which is out of focus
This is a follow up to a previous question I asked about how to update a textbox while typing. In my previous question, I had three textboxes, two of which were enabled and one which was not. They ...
0
votes
2answers
4k views
MSAccess - populate text box with value from query
I have a combo box and several text boxes on a form. When I select a value from the combo box I want it to run a query based on that value and populate the text boxes with the data returned by the ...
0
votes
2answers
446 views
Textbox “Like” Search
I have a form that I want to search for anything containing what is entered into a textbox. Right now the search only picks up data that matches exactly (ie MDD), but I want it to capture anything ...
0
votes
2answers
2k views
MS Access 2007 - Property for text box to allow end-user to hit enter for return, not next
So I have a form that user's use for data entry, and on one form there is a text box there that is basically used. To enter notes. However, if the user hits i need the cursor to stay in that text ...
0
votes
2answers
871 views
Input Mask without Year for date
Could anyone help me in inserting a input mask formula for date in a access form textbox
that shouldnot take year
which only take date and month
in the below format :
DD/MM
Not in DD/MM/YY
...
0
votes
2answers
3k views
How to make TextBox visible after an item in an option group is selected
This should be easy but for some reason it will not work. I have a form named MainForm and the selection in the Option Group I want to select is called PickMe.
I have a text box called TxtHere that ...
0
votes
1answer
486 views
MSAccess'03 VBA - Textbox contents are highlighted with cursor movement is UNdesired
I use VBA to copy a db field to a textbox for editing. When I move the cursor in the textbox, ALL text to the right is highlighted. I just want to edit the contents of the textbox as I would with ...
0
votes
1answer
815 views
MS Access 2007 text box values validate
I have an access form in which i enter some values...here once i enter n goto next textbox i want to check if the quantity entered in the text box is less than a value from a field in some table. i ...
0
votes
2answers
26 views
Loop through textboxes on access form and change the data
I am trying to change data when an access form opens. At the minute data says True and I would like to change that to say Yes instead. I have given it a go but I am new to vba and don't really know ...
