The Answer: (Was: TextBox Character Limit? (MS Access 2002 .adp connected to SQL))
- From: "HumanJHawkins" <Sorry@xxxxxxx>
- Date: Mon, 4 Apr 2005 14:59:47 -0700
"HumanJHawkins" <HumanJHawkins.1mujgm@xxxxxxxxxxxxxxxxxx> wrote in message
news:HumanJHawkins.1mujgm@xxxxxxxxxxxxxxxxxxxxx
>
> 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.
<CUT>
The answer is that Access will not send more than 255 chars to a varchar,
even if it can hold more. However, changing the varchar to a "Text" data
type works around this bug in Access.
Cheers!
.
- References:
- TextBox Character Limit? (MS Access 2002 .adp connected to SQL)
- From: HumanJHawkins
- TextBox Character Limit? (MS Access 2002 .adp connected to SQL)
- Prev by Date: Re: linking to Microsoft Project files
- Next by Date: Import from Excel Question
- Previous by thread: TextBox Character Limit? (MS Access 2002 .adp connected to SQL)
- Next by thread: How do I fix this error 'Microsoft Access can't save the output d.
- Index(es):
Relevant Pages
|
