wrap text in textbox

On my report, I have a textbox which is populated with data from a query.
Occasionally, the text is too long for the textbox and I need to wrap it onto the next line.
Is there anyway to do that?
I can't find a property for it at the moment...

Post your answer or comment

comments powered by Disqus
I'm new to MS Access and this forum. This may be a silly question but I cannot find answer anywhere: can I wrap text in the header columns of a table in Datasheet view as shown in the attachment?

BTW, I cannot make the column width wider because I want to display as many columns as possible.

Any help would be great appreciated. Thanks.

Dear Experts,

i want to set wrap text in my report on one field how can i do?


I generate a pivot table from a simple table databse and one of the memo field contains a fair amount of text and when I try to print my pivot table, it prints over 2-3 pages. Is there a way to wrap text in an Access Pivot Table?


I am trying to find out if you can wrap text in a combo box? I have multiple selections that I am chosing to insert into my form but some of the verbage is cut off. Is there a way to wrap the text so that it shows all the information selected?

I have a textbox control and it has a specified width. But if the number of characters are more to display in one line, then I want to wrap the text in the textbox.
The text that appears in the textbox is determined at runtime.

Is there a way to do that??

I'm trying to figure out how to move the cursor to end of text in a textbox after I set focus to the control. Right now all of the text is highlighted when the focus is set. The code I'm working with is very simple:

Private Sub cmdEditComments_Click()
Me.Comments.Locked = False
End Sub

I'm thinking I need to do something with Chr(3), but am not sure of syntax.


how i can select text in first.textbox and show in second.textbox?

My Idea :
Teble : Program
From : [2 textbox = frist and second],[1 button = click]

step 1. when i open my from. first textbox will show text.
step 2. i will select text in first textbox then click on button [click]
step 3. show my select text in textbox second

My question

step 1. how i can show text from table.?
step 2. how i can select text in first.textbox and show in second.textbox?

Help me Pls.

I'm new in this forum and am apealling to you for help.
I'm using a Listbox based on a Table, and I've selected "yes" on the Column Heads format option. Whenever the field name is bigger than the Column Width I defined it's cutted.
Since Access doesn't allow (I think) to put carriage returns or line feeds in Table fileds names (I tryed like this: MyDB.TableDefs("XTmpHosp0").Fields(8).Name = "RSU" & Chr(10) & Chr(13) & "A28I04"), I then tryed to put a space between words hopping that it would show the field name in 2 separate lines ("RSU A28I04") but it didn't work.
Is there a way to wrap text like you do for a Cell in Excell?
I'm using Access 97.


How can i limit the user to enter the text in a textbox on a form?
suppose i want the user to enter only upto 20 chars in a textfield.

Hi All,

Time to turn to the better minds again!

Instead of a label I'm using text in the format property of a textbox to identify fields on my form (using the following format: ;&"textstring"[red]).

This works fine and gets overwritten when I enter actual data and doesn't save the label/placeholder text into the underlying table if I don't overwrite it (which is not always necessary) BUT....

If I duplicate a record, when the duplicated record form appears any label/placeholder text that was not overwritten with actual data is now black and is being saved to the underlying table -somehow it's turned into 'live' information, rather than a placeholder. The format property in the property sheet has not changed and if I clear the textbox, the originally formatted label/placeholder returns (and is not saved down to the table).

This doesn't happen if I just move onto the next record in the form, only when I duplicate.

I'm guessing I should be adding some kind of update/refresh code but not sure what or where...

Hope that makes sense and someone can help.

Muchos gracias peeps!

Access 2010

Hi all,

I have a report with some text boxes on it. Sometimes the text in these boxes can be a very long string of chracters (maybe a path to some folder). In this case I do not want the text box to grow. I just want the report to show me the right-hand side of this path and cut off the left.
How do I do this when still aligning my text to the left?

Many thanks!

Would anyone happen to know how to wrap text in the Expression Builder box
in Access? In the 97 version, it automatically would wrap the text of
the formulas I built. In the 2002 version, it won't wrap.



Tried searching this forum and the web for an answer to this but not sure what exactly to search for to find an answer

What I am hoping to do is to put some text in a text box that would help the user inputting the data in a similar fashion that a search site would have a text box that might say 'enter search parameters' here - which would disappear once clicked on

Is this too complicated?


Is it possible to "wrap text" in a List Box. I using a list box below a report menu. The list box will show a description of the report which is selected from the list. The after update event is working fine. The problem is my list box results are all on one line and truncate most of the report description. How can I make all the text fit in the box displayed ?? Can this be done

Dear sir

Tell me please if I want wrap text in text box with symbol (etc. ; ) for new line.

Thank you

I would like to format text in a text field in a Report. For example.

This is a test of my formatting needs.

I understand that MS Rich Textbox doesn't work on reports. I tested them and could not get a bound RichText box control to preview or print.

Is there any way to embed printer formatting codes in a field that will format the printer? I assume it is printer specific?

Any sneaky ways of doing this would be greatly appreciated.

Thanks in advance for your help.

Hello. I want to format particular fields in a textbox. The textbox contains a paragraph, which includes a person's name. For example:

"Dear [NAME], you may have won a million dollars!"

I want the name to be in a different font. Is there a way to do this.

Note that I can't break it up into different text boxes. It has to be all in one textbox, so the paragraph flows properly.

I appreciate any help.


I have a subform appearing on a report (should I be using a subform or subreport?? I've tried both and don't really see the difference)

Anyway, the subform is in datasheet view. Is there a way to wrap the text so that it all displays in the report?

I'm getting the impression that it can only be done if I set the view to continous form and format it to look like a datasheet.

Thanks in anticipation!

name of textbox is txt_EnterDate

I want to be able to highlight the text in the textbox when i click into it with mouse, for easy editing

I could just clear it; txt_EnterDate = ""

but the user would need to see what date was previously entered

i've already used

Private Sub txt_EnterDate_GotFocus()

'If txt_EnterDate > "" Then
'txt_EnterDate.SelStart = 0
'txt_EnterDate.SelLength = Len(txt_EnterDate)
'End If

End Sub

Thanks for replies

Hi guys

I have a textbox that stores customer name so when the user starts typing the text in that textbox then it should convert into vbpropercase that means first letter capital and then rest of the letters small.:
If I use the following code on change event of the textbox then it doesn't work and Infact the textbox doesn't allow me to input anything:




Can I evaluate the Format of the Text entered in a Textbox?

I have a search box on a form that a user can enter various information into to search on...(driver license, phone#, etc...). Because one scenario causes problems, namely license# formatted "a-aaa-aaa-aaa-aaa-aa", contains three extaneous #'s at the end of the string, I would like to evaluate the Format of the text entered prior to searching using select case and eliminate those characters from the string. This is the only scenario that causes any problems.

I've been looking, but I can't find this.

Any direction is appreciated greatly.


I'm having some problems finding the proper VBA syntax for checking to see if the text in a textbox is contained in a combobox. I'd know how to do this in VB.Net, but unfortunately I'm using VBA.

I have a sub-form where all the data is bound from one table, and have added a combobox to this sub-form in which it is not bound, but gets it's data from a seperate table.

The main table that has everything bound has a field called "Type" that has user entered data, and several hundreds of records that have variations of the spellings or type, so I have made a seperate table that contains a list of the 8 or so main "Type"s, including one for Other which is not found in the Type field for the main table.

What I want to do is check to see if the value of the bound textbox of Type is one of the types in the Combo box, if it is I want to have the textbox be blank, the combobox's type to be selected.

If the type is not found in the combobox's list, I want to have the combobox to display "Other", have the bound textbox remain as it is with the type in it. Under this condition, if the textbox's text is misspelled and then corrected, or if a different value is picked from the combobox, it needs to change to the condition of where the textbox text is found in the combobox list.

On the update, it needs to change the textbox text back (as it's bound) to the value of the combobox text (unless the combobox is of type other, in which case it'll simply remain as the textbox value).

So, my question is how can I determine if the value of a textbox is listed in a combobox, and are there any other potential problems I should take into consideration?

I'm planning on doing all the loading on the Form Load event, and on the Form UnLoad Event I will put the value of the combobox back into the textbox.

Is there an easy way to put some descriptive text inside a textbox, have it grayed out, and when you enter text in the box, it overwrites this text? For instance, I have an Issues database. In the text field, I want to put the text as follows: Enter your issue here. Then when they type in that field, it overwrites that text with whatever they enter. Hope that makes sense.

Hello all,

I think I have a simple question. I have a regular form with name,address,phone and so forth. I am trying to display the name in the textbox but when you click or tab to the textbox the default text goes away. However if the field is blank then it will display default text...

Is this possible??


Not finding an answer? Try a Google search.