A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do i increase form cell lenth from 50 to 200 plus characters



 
 
Thread Tools Display Modes
  #1  
Old April 29th, 2008, 05:13 AM posted to microsoft.public.access.forms
mts
external usenet poster
 
Posts: 9
Default how do i increase form cell lenth from 50 to 200 plus characters

I am trying to find out how to increase my form cells from 50 characters to
200 plus. I want to be able in input data into the form, but I am limited to.
I am using Access 2003.
  #2  
Old April 29th, 2008, 06:34 AM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default how do i increase form cell lenth from 50 to 200 plus characters

MTS,
look for the table that the form is based on.
Open that table in design view, find the fields that need extra length.
For each of those fields change the field length to a higher number.
The maximum size for a text field is 255.
If you have too many text fields with 255 characters in them,
(that means if users input 255 characters in too many textboxes in the form)
all in the same record, you will run into the limit for a single record.


Jeanette Cunningham


"MTS" wrote in message
...
I am trying to find out how to increase my form cells from 50 characters to
200 plus. I want to be able in input data into the form, but I am limited
to.
I am using Access 2003.



  #3  
Old April 29th, 2008, 06:37 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default how do i increase form cell lenth from 50 to 200 plus characters

On Mon, 28 Apr 2008 21:13:01 -0700, MTS wrote:

I am trying to find out how to increase my form cells from 50 characters to
200 plus. I want to be able in input data into the form, but I am limited to.
I am using Access 2003.


You are not inputting data into a Form.

You are using a Form *as a tool* to input data into a Table. Data exists in
tables, and only in tables; forms are just windows.

Open the Table upon which the form is based in design view and select this
field. Change its size to 255 bytes (the maximum size of a Text datatype) if
that's adequate for you. If you need more (up to a billion bytes,
theoretically) change the datatype from Text to Memo.
--

John W. Vinson [MVP]
  #4  
Old April 29th, 2008, 01:07 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default how do i increase form cell lenth from 50 to 200 plus characters

If you have too many text fields with 255 characters in them, (that means if users input 255 characters in too many textboxes in the form) all in the same record, you will run into the limit for a single record.

I wasn't aware that there was a "limit" for a single record. Exactly what is
that limit?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

  #5  
Old April 29th, 2008, 01:21 PM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default how do i increase form cell lenth from 50 to 200 plus characters

"Linq Adams via AccessMonster.com" u28780@uwe wrote in message
news:8366bcf1e78c0@uwe...
If you have too many text fields with 255 characters in them, (that means
if users input 255 characters in too many textboxes in the form) all in
the same record, you will run into the limit for a single record.


I wasn't aware that there was a "limit" for a single record. Exactly what
is
that limit?


I can never remember whether it's 2000 or 4000 bytes.

Easy enough to write a test to determine, though. Create a table with, say,
20 fields defined as Text(255).

Start writing records to the table, adding a character for each record,
until you can't write anymore.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



  #6  
Old April 29th, 2008, 05:43 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default how do i increase form cell lenth from 50 to 200 plus characters

On Tue, 29 Apr 2008 12:07:32 GMT, "Linq Adams via AccessMonster.com"
u28780@uwe wrote:

If you have too many text fields with 255 characters in them, (that means if users input 255 characters in too many textboxes in the form) all in the same record, you will run into the limit for a single record.


I wasn't aware that there was a "limit" for a single record. Exactly what is
that limit?


From Help... Specifications:

Number of characters in a record (excluding Memo and OLE Object fields) when
the UnicodeCompression property of the fields is set to Yes: 4,000

Interesting that it's not 4095 or 4096 or some other power of two!

It's a rather nasty limitation, because you can easily create a table with
multiple text fields; it will work fine initially, and you can go for months
until someone with a verbose streak actually USES all 25 of the 255-byte text
fields.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.