69 character limit in a field how to change ?

[DBenz]

Hi, My access dbase , entering data in one of thew boxes on the form, gets to 69 chars and then donk donk I can't type any more.
I have selected that field in design view on the form , gone right click properties but not sure where the limit is set and then I can perhaps alter it.
whats the way to solve this ?

Perhaps I need to find the table and the field in the table, again tried that but still not seeing where to look etc.



other fields on the form are ok.

In table view its data type is Short Text and field size 70 so now alter it to 110 but has made no difference !
closed form and reopened it, still no difference.

Cheers

DBenz

[Gicu]

Open the form in design view and look in the Control Source property of the textbox, that will give you the field name. Next click on the top left square of the form itself to see the property window for the form and look for the Record Source property of the form which will give you the table name (or a query based on it). Now close the form and open the table in design view, go to your field and modify its Field Size property to your liking.
Cheers,

[pbaldy]

The record source property of the form will tell you the table/query the form is based on. Check the table field in design view to see what the limit is.

[Micron]

Put that table in design view. Select the field that the textbox is bound to. Look at the properties of that field and see if there is a character limit imposed on it. By default, it is 255 but may be less. If the level of 69 or similar isn't set, then it may be being limited by code. In that case, put the form in design view, select the control and look at the Event tab on the property sheet. It could be one of a few events where this might be the limitation is.

[DBenz]

Hi, Thanks all, Followed firstly Gicu, and the limit was 70, altered to 110 and thats done it, odd that as did that just now and nothing changed.
I would like it longer but the box isnt big enough, and no room to make it bigger. Can I make the box have a scroll thing at the side ?
how is that done ?

Cheers

DBenz

[Micron]

If you click in the textbox you can move the cursor to the end via the arrow key. Is that good enough?

[pbaldy]

Textboxes have a scroll bars property you can set. You can also hit Shift-F2 while in the textbox to get a popup box (that can also be automated).

[DBenz]

Textboxes have a scroll bars property you can set. You can also hit Shift-F2 while in the textbox to get a popup box (that can also be automated).

Hi,
exactly where is that, how to get at it etc ?
I had clicked that text box in design view and chosen 'properties' as opposed to 'form properties' but couldnt see anything.

other workarounds ok but its neat to have the scroll bar.

Cheers

DBenz

[Minty]

In the property sheet under the Format Tab, about half way down, is a property called Scroll Bars: