473,568 Members | 2,738 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

textbox size limit with sql

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
1 5001
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
6032
by: steve | last post by:
I am setting up a huge database in mysql, and I get the above error in Linux. I believe it is related to the size of one of my tables, which is 4,294,966,772 bytes in size. Can someone help. How can I break that barrier. A google search did not turn up anything useful. -- Posted using the http://www.dbforumz.com interface, at author's...
2
28546
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
12
1344
by: Hugh Janus | last post by:
Hi group, I have a form with a textbox control on it. I am using the textbox control with multiline enabled to output the 'log' information for a long process I am running. My problem is that it all works fine until the limit of the size of text is reached for the text box. This causes the textbox to stop update whilst the thread running...
2
3376
by: Calvin KD | last post by:
Hi everyone, I have a number of textboxes, lined up in a html table. I have split the table into different columns. The column widths are all relative, that is, % rather pixels or points so that it can grow / shrink. The textboxes are then placed into table cells and have their widths to be 100% of the width of their container (table cells)....
13
2416
by: Randy Jackson | last post by:
Hello, I'm creating a sample portfolio application for MS-Access XP, and I'm wondering if there's a suitable replacement for the ms-access textbox control. I'm looking for something similar to an HTML textarea control, but without rich text formatting. I know you can just use a regular textbox and expand it, but it still has size...
10
2448
by: garyusenet | last post by:
I have a multiline textbox. The size of the text box should be 75 characters wide, and 5 lines in height like this: - <---75 characters--> <---75 characters--> <---75 characters--> <---75 characters--> <---75 characters-->
1
2246
by: kowndinya | last post by:
Hai, Is there any way to limit the input data to the width of of the textbox itself. I don't want scroll data when user keyins. I don't want to use Max length concept because some times user may change font size, hence the number of characters may change. The reason is, i want to print this form with these textboxes after data entry If i enter...
7
2883
by: robert.waters | last post by:
I have an Access database frontend linked via ODBC to a large (gigabytes) mysql database. I need to view a large amount of data in a a textbox (variable up to 300K), but I receive a 'there isnt enough memory' error whenever I scroll past N number of bytes in a textbox that has been filled with a lot of data. I am not sure what N is, but for...
0
1249
by: tshad | last post by:
I seem to have hit some sort of limit of a textbox (multiline). It was working fine for a while, but now I am getting a strange error having nothing to do with the problem. I have a Function that is called either from my Windows Service as well as call as an .exe. There is no actual error from writing to the text box, but as I am leaving...
0
7604
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7916
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7660
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5498
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2101
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1207
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
932
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.