473,322 Members | 1,671 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Textbox replacement?


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 limitations that I'm needing to overcome.

I imagine I could build one, but if someone else has re-created the wheel
I'd just as soon use that. If anyone knows of anything, please let me
know.

--
Randy Jackson
HTTP://FourColorConsulting.com
Apr 4 '06 #1
13 2400
"Randy Jackson" <ra**********@nounsolicitedfourcolorconsulting.com > wrote in
message news:Xn**********************************@216.196. 97.142...

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 limitations that I'm needing to overcome.

I imagine I could build one, but if someone else has re-created the wheel
I'd just as soon use that. If anyone knows of anything, please let me
know.

http://www.lebans.com/richtext.htm
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Apr 4 '06 #2
"Rick Brandt" <ri*********@hotmail.com> wrote in news:6WCYf.44724$_S7.39697
@newssvr14.news.prodigy.com:
http://www.lebans.com/richtext.htm


I'll check this out, but I'm really looking for a plain text replacement.

--
Randy Jackson
http://fourcolorexplosion.com
Apr 4 '06 #3
"Randy Jackson" <ra**********@nounsolicitedfourcolorexplosion.co m> wrote in
message news:Xn**********************************@216.196. 97.142...
"Rick Brandt" <ri*********@hotmail.com> wrote in news:6WCYf.44724$_S7.39697
@newssvr14.news.prodigy.com:
http://www.lebans.com/richtext.htm


I'll check this out, but I'm really looking for a plain text replacement.


Sorry. I misread your original message. What limitation exactly are you hitting
with the standard TextBox?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Apr 4 '06 #4
Now that's the kind of answer that could make you an MVP.<gd&r>
Congratulations Rick.
:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:6W*******************@newssvr14.news.prodigy. com...
"Randy Jackson" <ra**********@nounsolicitedfourcolorconsulting.com > wrote
in message news:Xn**********************************@216.196. 97.142...

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 limitations that I'm needing to overcome.

I imagine I could build one, but if someone else has re-created the wheel
I'd just as soon use that. If anyone knows of anything, please let me
know.

http://www.lebans.com/richtext.htm
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Apr 5 '06 #5
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote
in message news:7I********************@ursa-nb00s0.nbnet.nb.ca...
Now that's the kind of answer that could make you an MVP.<gd&r>
Congratulations Rick.
:-)


Thanks.

Whenever I see someone looking for "a previously invented wheel" in Access, your
site is always the first thing that comes to mind.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Apr 5 '06 #6
"Rick Brandt" <ri*********@hotmail.com> wrote in
news:az*******************@newssvr14.news.prodigy. com:
Sorry. I misread your original message. What limitation exactly are
you hitting with the standard TextBox?


I guess someone hadn't had his coffee today... :D

The problem I'm running into is one of text length.

I actually am attempting to reinvent the wheel in some aspects. I'm
working on a limited HTML CMS (once again, this is to show some of my
abilities) and I'm running into issues with the SelText property--or for
that matter of fact, issues with size limitations for textboxes in general.

When I attempt to change the contents of the entire textbox, I keep running
into error 2176, which indicates that I'm trying to fit too much data into
too small a space.

I'm not working with bound fields or anything, and I suppose it's possible
there's a setting that will make this issue go away, but I'm not finding it
at the moment. If anyone has any ideas, that would be great.
--
Randy Jackson
http://fourcolorexplosion.com
Apr 5 '06 #7
Randy Jackson <ra**********@nounsolicitedfourcolorexplosion.co m>
wrote in news:Xn*********************************@216.196.9 7.142:
The problem I'm running into is one of text length.


That has nothing to do with the control you're using. That is an
issue of the data type of the underlying field you're storing the
data in. The standard Jet text datatype has a limit of 255
characters. If you need more, you have to use the memo field, which
has a limit of 64KB. If that is insufficient, you have to go to a
BLOB field, which is not well-supported in the Access UI.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Apr 5 '06 #8
"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in
news:Xn**********************************@127.0.0. 1:
Randy Jackson <ra**********@nounsolicitedfourcolorexplosion.co m>
wrote in news:Xn*********************************@216.196.9 7.142:
The problem I'm running into is one of text length.


That has nothing to do with the control you're using. That is an
issue of the data type of the underlying field you're storing the
data in. The standard Jet text datatype has a limit of 255
characters. If you need more, you have to use the memo field, which
has a limit of 64KB. If that is insufficient, you have to go to a
BLOB field, which is not well-supported in the Access UI.


I'm not sure I follow. Considering the field is unbound, it shouldn't make
a difference, right?

--
Randy Jackson
http://fourcolorexplosion.com
Apr 5 '06 #9
Randy Jackson <ra**********@nounsolicitedfourcolorexplosion.co m>
wrote in news:Xn**********************************@216.196. 97.142:
"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in
news:Xn**********************************@127.0.0. 1:
Randy Jackson <ra**********@nounsolicitedfourcolorexplosion.co m>
wrote in news:Xn*********************************@216.196.9 7.142:
The problem I'm running into is one of text length.


That has nothing to do with the control you're using. That is an
issue of the data type of the underlying field you're storing the
data in. The standard Jet text datatype has a limit of 255
characters. If you need more, you have to use the memo field,
which has a limit of 64KB. If that is insufficient, you have to
go to a BLOB field, which is not well-supported in the Access UI.


I'm not sure I follow. Considering the field is unbound, it
shouldn't make a difference, right?


There is no limit on the length of the data that can be placed in an
unbound Access textbox.

Ooops. I'm wrong. The length limit is 64000 characters.

I don't know if Steve's rich-text control has a longer limit or not.
That it's a rich-text control should not prohibit you from storing
plain text in it, no?

I assume you're referring to the length of the data, not the
onscreen size of the control?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Apr 6 '06 #10
Ooops. I'm wrong. The length limit is 64000 characters.

I don't know if Steve's rich-text control has a longer limit or not.
That it's a rich-text control should not prohibit you from storing
plain text in it, no?

I assume you're referring to the length of the data, not the
onscreen size of the control?


Yes, it seems to be a limitation of the length. The size of the control is
not an issue.

I could use the rich-text control, but I would prefer to use a plain text
field because I want to code it myself (the rich text functionality).
--
Randy Jackson
http://fourcolorexplosion.com
Apr 6 '06 #11
Hi. Just thought I'd let you know I figured a way to do it. It was a
simple matter of setting the textbox's value property instead of the text
property.

Thanks so much for your help.

--
Randy Jackson
http://fourcolorexplosion.com
Apr 8 '06 #12
Randy Jackson <ra**********@nounsolicitedfourcolorexplosion.co m>
wrote in news:Xn**********************************@216.196. 97.142:
Just thought I'd let you know I figured a way to do it. It was a
simple matter of setting the textbox's value property instead of
the text property.


???

The .Text property is only available when the control has the focus.

A control's default property is the .Value property, so you don't
need to set *any* property, just assign a value to the control
itself:

Me!TextBox = [whatever]

What background are you coming from that you'd think you needed to
set the .Text property?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Apr 8 '06 #13
"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in
news:Xn*********************************@127.0.0.1 :
Randy Jackson <ra**********@nounsolicitedfourcolorexplosion.co m>
wrote in news:Xn**********************************@216.196. 97.142:

What background are you coming from that you'd think you needed to
set the .Text property?


I'm just returning to Access programming after a fairly lenghthy hiatus, so
there are things I'm going to occasionally hit myself over the head and say
"D'oh!" over. This was one of them.

--
Randy Jackson
http://fourcolorexplosion.com
Apr 9 '06 #14

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

53
by: Kerberos | last post by:
I followed Dan Cederholm's image replacement tutorial, to replace a header tag by a logo. The h1 is clickable if no CSS is applied but it I replace it by the logo, the area isn't clickable anymore...
3
by: Vibha Tripathi | last post by:
Hi Folks, I put a Regular Expression question on this list a couple days ago. I would like to rephrase my question as below: In the Python re.sub(regex, replacement, subject)...
6
by: dyw55a | last post by:
How to implement mm/dd/yyyy format for textbox? I have text box with format mm/dd/yyyy. Now I want the cursor i generated whenever user highlight this textbox and whatever user inpu replace one...
14
by: Adam Clauss | last post by:
I've an application which is using a multiline textbox to log the status of a fairly long procedure. "Updates" are made to the status by calling textbox.AppendText. As my task is fairly lengthy,...
0
by: Eddie Hadley | last post by:
I find it very easy to intercept a mouse event in a textbox in a windows app, and thus do my own thing. But the app will insist on doing its own thing as well! Specifically, I want to be able to...
0
by: Mike | last post by:
Hi All, I mistakenly just posted this to the VB group. Sorry for the cross-post. I am working with a textbox in C# which pulls a set of lines (stored in the database as text_type,...
2
by: Pham Nguyen | last post by:
Has anyone seen an example of a textbox server control that has built-in client-side validation? I'd like to build a server control that extends the System.Web.UI.WebControls.TextBox class to allow...
4
by: Jason Cowsill | last post by:
Hi - I am looking for a way to dynamically alter a textbox WHILE the user is typing in it. One example would be while a user is entering their phone number a dash would be entered automatically...
1
by: lawrence k | last post by:
Want to replace the limit clause in a query, but can't get it right. What's wrong with this: $pattern = "(.*)limit (.*)"; $replacement = '$1'; $replacement .= "LIMIT $limit"; $replacement .=...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.