Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String = fielda & fieldb statement results in truncation

Status
Not open for further replies.

chopsuey2

Programmer
Aug 24, 2004
12
0
0
HK
Hi

Interesting little problem here. Have a build string statement:-

string = fielda & fieldb

Fieldb is larger than 1024 as it is a textline for a letter.

When I look at the string field, fielda is there and complete but fieldb has been truncated to 1024 characters!

Anybody know of any restrictions when building strings?

Many thanks
 
Where are you displaying the text?
A text field, data type allows max 250.
But obviously, if it is a text box, you're displaying it in, you have it set to Memo type, which allows a few thousand, I believe.
I can't figure out where you're displaying this, because you seem to be, somewhere in between a Memo data type, and a text data type?

Lastly, I'm assuming string, is not a fixed length variable?
You did not fix its length, at time of declaration?
Dim string As String * 2000
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top