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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|