TextBox Character Limit? (MS Access 2002 .adp connected to SQL)
- From: HumanJHawkins <HumanJHawkins.1mujgm@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 2 Apr 2005 00:23:48 -0500
I have an SQL DB (MS SQL Server 2000 SP 3) with a varchar(1024) field in
it.
I have made an .adp interface for this data. I am trying to allow users
to enter data in _other_ fields and use VB to concatenate other fields
into this 1024 char long field. However, whenever the concatenation
exceeds 255 characters it fails. Oddly, instead of truncating it at
255, it only shows the remaining text after the first 255 characters.
So, if the text is under 255, it works perfectly. But if I go one word
over, the only thing in the text box is that one word that went over.
I am using a standard textbox from the Access tool pallette. The syntax
is very simple, as in (where I have 3 text boxes, each named "Combined",
"Source1", and "Source2"):
Code:
--------------------
Function CombineFields()
Combined = Source1 & Source2
End Function
--------------------
I think the chopping off happens between VB and the text box after I am
done with it... In the debugger, I can see that the strings are fine
when the function is done with them. And, I know the text box can hold
more, because I can type more than 255 chars into it just fine.
Any tips on how to either make this work, or make another solution
would be much appreciated!
Thanks!
--
HumanJHawkins
------------------------------------------------------------------------
HumanJHawkins's Profile: http://www.msusenet.com/member.php?userid=337
View this thread: http://www.msusenet.com/t-1869388021
.
- Follow-Ups:
- Prev by Date: Re: how do i import a directory file list into an access table
- Next by Date: Re: Return Code from receive | coding a receive in Access
- Previous by thread: How can I save my auto correct settings? To move to a new PC?
- Next by thread: The Answer: (Was: TextBox Character Limit? (MS Access 2002 .adp connected to SQL))
- Index(es):
Relevant Pages
|
