Increasing Characters in a text box

[djsmiler]

Hi All

I am trying to increase the ammount of characters that I can type in a text box as there isnot enough space to type all the information that I need.

Is there any way of doing this ?

Cheers

Steve

 

[Guus2005]

If the textbox is great enough, has enough height, it will show you a scrollbar.
when it is not, try programming the Tooltiptext with the value of the textbox.
something like:

me.txtName.Tooltiptext = me.txtName

When hovering over the control it shows the contents of the textbox.

 

[kidrobot]

try using a memo if that doesn't work.

 

[virgosam20]

Have you tried changing the number of characters for the field in the Table Design view? Its usually set at 50, but you can alter it. Although if you are going to be typing alot, I would take Kidrobot's advice and change the field to a Memo rather than a general Text Box.

 

[missinglinq]

Your post is a little fuzzy as to your exact problem, Steve, which is why the answers have been so varied!

If you mean that you need to be able to enter more characters than Access currently allows then, as suggested by virgosam, goto the table's design view and increase the Field Size for the field in question.

If you mean that the textbox on your form is too small to allow you to enter and see all of your data at one time, and for whatever reason you cannot simply make the textbox longer (I have to assume you know how to do that) the the easiest answer is to use the Zoom command. This code will allow you to Double-click on the textbox in question and it will temporarily expand the box.

Private Sub YourTextBoxName_DblClick(Cancel As Integer)
  DoCmd.RunCommand acCmdZoomBox
End Sub

This last thing is very important! Only convert your field from a text field to a memo field if you absolutely have to have more than 255 characters and if you do not foresee having to do any manipulation of data based on the field! That means no sorting by it, using it as criteria for anything, counting up the number of times certain words/phrases appear or anything else. Queries do not like memo fields, and most types of queries will truncate them to 255 characters!

Memo fields are great, as long as they're used as intended, to simply hold memos/notes.

 

[djsmiler]

Thanks for your help guys.

I have sorted this now