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

textbox size limit with sql

P: n/a
I'm hitting the 255 character limit of a text box on a form and was
wondering if anyone know how to get around this.

Here the scenario....

- Access 2000 front end with Sql Server backend.
- The textbound is bound to a field which is nvarchar*4000 (I know with
an Access DB you have to use a memo field to get around the size limit,
I would think nvarchar*4000 would be good enough)
- The 255 character limit only occurs in the VBA code. I could type
all 4000 chars in the text box and save the record with no problem.
However, it's only in the VBA code that the size of the text box get's
cutoff at 255. Maybe a different datatype will do the trick.
Thanks in advance for any help.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SpreadPeace wrote:
I'm hitting the 255 character limit of a text box on a form and was
wondering if anyone know how to get around this.

Here the scenario....

- Access 2000 front end with Sql Server backend.
- The textbound is bound to a field which is nvarchar*4000 (I know with
an Access DB you have to use a memo field to get around the size limit,
I would think nvarchar*4000 would be good enough)
- The 255 character limit only occurs in the VBA code. I could type
all 4000 chars in the text box and save the record with no problem.
However, it's only in the VBA code that the size of the text box get's
cutoff at 255. Maybe a different datatype will do the trick.
Thanks in advance for any help.


I've not worked with such large strings when using SQL from VBA but if I
were in your shoes I would start by using SQL Profiler to see what SQL
is being generated when you save the record normally from the form.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.