Grow text box on form with focus
I usually have only a few words to put in a "notes" field. But sometimes, I need to enter an explanation, and then look back and review it later.
I would like to have the text box expand to view all the text when I click on the field (got focus?) and then return to it's original size when I leave the field.
If I make the height on the text box bigger, it takes up too much real estate on my form. I would like it to pop open or zoom and then return to normal.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The problem is it moves everything else down on the page. I am aware of limiting characters. I have the setting "Can Grow" set to yes, what I want is for the text box to grow horizontally and not vertically
I tried adding an unbound text box (for a compamy name and address) - but it didnt grow with the data.
I found the help a little unclear
However afterwards the text box loses focus and I can't set the focus to the text box in its lostfocus() event.
I am working with Microsoft Access 2003.
The fields are able to "grow" however the "grid" loses it's formating when one fields grows and the others stay the same.I have set all the fields to grow, didn't work. I though maybe by grouping all the field together they would be forced to grow to the largest field but there doesn't seem to be an option for this?
Master Form - Catagory = Regular Wheel (text box on focus opens Regular Wheel Box Form)
Master Form - Catagory = Yesteryear (text box on focus opens Yesteryear Box Form)
Master Form - Catagory = Superfast (text box on focus opens Superfast Box Form)
I have a few more catagories but this should get you the gist of what I am trying to do
When the form is opened, a default radio button is selected, and focus is on the combo box where the user enters the first data. The problem I'm trying to solve is that, when the user selects the 2nd radio button, focus remains there, and they have to click or tab to the combo box to continue data entry. I would like to programatically move focus back to the combo box when the other radio button is selected so that they can continue from there.
Should be simple, I though, but can't figure out how to do that. Using SetFocus to move focus back to the combo box when either radio button is clicked (OnGotFocus) doesn't work
I'm using Access 2010 and I needed a report in my navigation form, but I wanted the user to be able to filter from an unbound text box and click a button to open the report in print preview.
I finally went with a form containing a subreport and the text box and buttons. It worked ok, but the subreport wouldn't grow or shrink.
I finally got it to work by changing the Vertical Anchor property for the subreport control to "Both".
Hope this helps someone out there
1) combo box displaying the different fields that can be searched.
2) a text box used to enter a string to be searched for in the chosen field
3) a command button that executes the search
What I would like to know is how do I change the focus to the text box after making a choice in the combo box, and then be able to hit Enter to activate the command button.