By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

How do I paste a VLS (very long string) into a textbox control on another form?

P: n/a
MLH
I'm having trouble pasting a VLS into a textbox
control on FormB. FormB is open in form view.
I'm trying to do it from a procedure running in
FormA. I'm up against 2048-Char limits no matter
how hard I try.

Funny thing is, I can easily hilite, cut 'n paste
into the control manually - no problem. I just
can't accomplish it from within code.

Ideas?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
So does
Forms("FormB").Text0 = "VLS Over 2048 Characters ..."

Not work?

(You'll need to replace Text0 with the appropriatecontrol name)

Terry
"MLH" <CR**@NorthState.net> wrote in message
news:qu********************************@4ax.com...
I'm having trouble pasting a VLS into a textbox
control on FormB. FormB is open in form view.
I'm trying to do it from a procedure running in
FormA. I'm up against 2048-Char limits no matter
how hard I try.

Funny thing is, I can easily hilite, cut 'n paste
into the control manually - no problem. I just
can't accomplish it from within code.

Ideas?

Nov 12 '05 #2

P: n/a
On Wed, 24 Sep 2003 14:22:09 -0400 in comp.databases.ms-access, MLH
<CR**@NorthState.net> wrote:
I'm having trouble pasting a VLS into a textbox
control on FormB. FormB is open in form view.
I'm trying to do it from a procedure running in
FormA. I'm up against 2048-Char limits no matter
how hard I try.

Funny thing is, I can easily hilite, cut 'n paste
into the control manually - no problem. I just
can't accomplish it from within code.


According to the help, the .Text property is limited to 2048
characters, something I hit a while back and was unable to resolve. I
had no problem setting the .Value property, which got the text into
the textbox but would not fire off any event procedures.

It appears to be a limitation of VBA.

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #3

P: n/a
MLH
Thx, guys... but my problem turned out
to be related to something else entirely.
Sorry about that - I'm easily confused.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.