Topics Search

Grow text box on form with focus

Grow text box on form with focus
Views: 32
I have a subform set up in continuous forms.

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.
Sponsored Links:

More topics


Text box resize horizontally

Is there a way to have a text box that will resize itself horizontally depending on the size of the data? The can grow property allows it to grow vertically which I don't want. If there isnot an easy way to do it I would imagine there would be a way to do it with VBcode.

txtbox moves everything else down

In my report if I have a text box that has 10.1' and the size of the textbox is too short so it appears like this:
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

Can Grow/Shrink

does this only apply to BOUND textboxes?

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

Preventing a control from losing focus

I am currently working on a project where I am using a bar code scanner that enables people to scan their employee ID and another bar code from a piece of paper. The scanner scans the code to a text box that has focus.

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.

Gridlines that can grow

I have 10 fields in a report, all with thin solid lines around each field to form a grid (similar to an Excel spreadsheet). Most of the fields will never grow as the data is something simple (date, yes/no etc), however a couple fields are allowed to grow depending on how much text is in them.

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?

On Focus Open Form????

I have a "Master Form" where I enter models onto a table. I also have a text box on that form that (on focus) it opens another form showing all the "regular wheel boxes" that are available for that model. I would like to set this up so that (on focus) it will open the "regular wheel boxes" form when the "catagory" for the model is set to "regular wheel" if the "catagory" field shows "yesteryear" then I want it to open the "Yesteryear boxes" form. I know this might be a little confusing but to break it down:

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

Moving Focus From Radio Button After Selected

I have a form with two radio buttons in an option group, a combo box, and several text fields. The selected radio button together with the data typed or selected in the combo box drop down are used to create a query to populate some of the text fields elsewhere in the form.

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

Finally got my subReport to grow and shrink!

I've been fighting with this thing for a while, searching all over the internet, and I finally stumbled onto the solution with random clicking

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

Set focus on first text box on first tab page and go to next record

In Access 2003/XP/2000/97, I have a form with a main tab box (created with a tab control) with multiple tab pages. When the user is on the last text box on the last tab page and presses the tab key, how can I set the focus to the first text box on the first tab page and go to the next record in the form?

Changing focus on a form

I have a search form that has:
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.