Text Box with Memo Capability?

[Guest]

I have a form with a Text Box without a Control Source. When closing this
form, I post the information in the Text Box to a Memo field in a table. The
problem is that there appears to be a 512 character limitation.

Is there any way to set a Text Box as Type = Memo?

Thanks in advance for your assistance.

Gary

 

[Rick Brandt]

I have a form with a Text Box without a Control Source. When
closing this form, I post the information in the Text Box to a Memo
field in a table. The problem is that there appears to be a 512
character limitation.

Is there any way to set a Text Box as Type = Memo?

Thanks in advance for your assistance

You're mistaken. A TextBox on a form cna have approximately 64000
characters typed into it. Your "post" routine is likely truncating the
data.

 

[Guest]

Thanks for the response, Rick. Makes sense, but all I'm doing is using an
append query to post the Text Box in the form to a Memo field in the table
(???). Here's the query field:

Field: SetMemoField: Forms!frmA!TxtBoxB
Append To: MemoFieldName

Is there any way to set the format of the "SetMemoField" to Memo?

Thanks again.

Gary

 

[Rick Brandt]

Thanks for the response, Rick. Makes sense, but all I'm doing is
using an append query to post the Text Box in the form to a Memo
field in the table (???). Here's the query field:

Field: SetMemoField: Forms!frmA!TxtBoxB
Append To: MemoFieldName

Is there any way to set the format of the "SetMemoField" to Memo?

Again, there is no such setting for a query. I have never appended from a
form control using that method. I would usually do it in code with
something like...

CurrentDB.Execute "INSERT INTO TableName (FieldName) VALUES('" &
Forms!frmA!TxtBoxB & "')", dbFailOnError

Do you have any formatting on the TextBox?

 

[Guest]

I'm appending numerous form controls with the query so it's easier this way.
There's no formatting in the Text Box.

Any other suggestions?

 

[Rick Brandt]

I'm appending numerous form controls with the query so it's easier
this way. There's no formatting in the Text Box.

Any other suggestions?

If you type...

?Forms!frmA!TxtBoxB <Enter>

....into the Immediate window do you get the entire entry or is it truncated?

 

[Guest]

Truncated.

If you type...

?Forms!frmA!TxtBoxB <Enter>

....into the Immediate window do you get the entire entry or is it truncated?

 

[Rick Brandt]

Truncated.

And the InputMask and Format properties for that TextBox are blank?

Do you find that you can type more than 512 characters into the box and all
of those beyond 512 are lost when you tab out of the control? I have seen
this when a format was applied, but it has alwyas truncated at 255
characters when I have seen it. I have no idea what would truncate the data
at 512 characters.

Are you quite certain that the number of character truncation is 512?

 

[Guest]

And the InputMask and Format properties for that TextBox are blank?

### Yes

Do you find that you can type more than 512 characters into the box and all
of those beyond 512 are lost when you tab out of the control?

### I typed over 2500 characters and they remained after I tab out of the
control.

I have seen this when a format was applied, but it has alwyas truncated at 255
characters when I have seen it. I have no idea what would truncate the data
at 512 characters.
Are you quite certain that the number of character truncation is 512?

### Not sure if it's consistent, but 512 is what remains after the append.
My sense is that you're on the right track with the Append Query ... I would
like to work around this and still use the query (if at all possible).

 

[Rick Brandt]

### Not sure if it's consistent, but 512 is what remains after the
append. My sense is that you're on the right track with the Append
Query ... I would like to work around this and still use the query
(if at all possible).

Well if you saw the truncation in the immediate window then the query is not
the problem.

 

[Guest]

512 remains AFTER the append ... all of the data is there when I look at the
Immediate Window (and after I tab to another control).

Any other suggestions/ideas, Rick?

 

[Rick Brandt]

512 remains AFTER the append ... all of the data is there when I look
at the Immediate Window (and after I tab to another control).

Wait a minute...so you're saying that the TextBox which is used as the
"source" of the append query is being truncated only after the append query
runs? I fail to understand how the append query can have any effect on a
TextBox that it is using to pull data "From".

I will run some tests to see if I can duplicate.

 

[Guest]

To clarify:

1) 2500 characters entered into Text Box.
2) Tab to another field, 2500 characters remain in Text Box.
3) Append Query runs (using Text Box as source to Memo Field in table).
4) Form closes
5) Memo field in table truncates 2500 characters to 512 (in this example,
anyway).

 

[Rick Brandt]

To clarify:

1) 2500 characters entered into Text Box.
2) Tab to another field, 2500 characters remain in Text Box.
3) Append Query runs (using Text Box as source to Memo Field in
table). 4) Form closes
5) Memo field in table truncates 2500 characters to 512 (in this
example, anyway).

My test...

1000 characters in TextBox (all "~" tidas)

Access 97 won't run the query at all (Text is too long error)

Access 2000 won't run the query, but doesn't raise an error either (just
does nothing).

Access 2002 and 2003 both run the query and all 1000 characters are appended
to the table. In the datasheet preview of the append query the data from
the TextBox does look strange with some funny characters at the end (see
below)

"...~~~~A??"

The last two non-printing characters do end up in the table result.

My conclusion is that using a form reference as an append source like that
just doesn't work right.