|
Home > Archive > MS Access database support > April 2006 > Textbox replacement?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Textbox replacement?
|
|
| Randy Jackson 2006-04-04, 8:30 pm |
|
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
| |
| Rick Brandt 2006-04-04, 8:30 pm |
| "Randy Jackson" < randyjackson@nounsol
icitedfourcolorconsu
lting.com> wrote in
message news:Xns979BB504626E
0RandyJacksonfourcol
o@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
| |
|
|
| Rick Brandt 2006-04-04, 8:30 pm |
| "Randy Jackson" < randyjackson@nounsol
icitedfourcolorexplo
sion.com> wrote in
message news:Xns979BBA2562E6
DRandyJacksonfourcol
o@216.196.97.142...
> "Rick Brandt" <rickbrandt2@hotmail.com> wrote in news:6WCYf.44724$_S7.39697
> @newssvr14.news.prodigy.com:
>
>
> 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
| |
| Stephen Lebans 2006-04-04, 8:30 pm |
| 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" <rickbrandt2@hotmail.com> wrote in message
news:6WCYf.44724$_S7.39697@newssvr14.news.prodigy.com...
> "Randy Jackson" < randyjackson@nounsol
icitedfourcolorconsu
lting.com> wrote
> in message news:Xns979BB504626E
0RandyJacksonfourcol
o@216.196.97.142...
>
>
> 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
>
| |
| Rick Brandt 2006-04-04, 8:30 pm |
| "Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote
in message news:7IDYf.55033$VV4.949356@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
| |
| Randy Jackson 2006-04-05, 3:31 am |
| "Rick Brandt" <rickbrandt2@hotmail.com> wrote in
news:azDYf.44734$_S7.11174@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
| |
| David W. Fenton 2006-04-05, 11:36 am |
| Randy Jackson < randyjackson@nounsol
icitedfourcolorexplo
sion.com>
wrote in news:Xns979C674218A7
RandyJacksonfourcolo
@216.196.97.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/
| |
| Randy Jackson 2006-04-05, 1:44 pm |
| "David W. Fenton" <XXXusenet@dfenton.com.invalid> wrote in
news:Xns979C7347175C
Df99a49ed1d0c49c5bbb
2@127.0.0.1:
> Randy Jackson < randyjackson@nounsol
icitedfourcolorexplo
sion.com>
> wrote in news:Xns979C674218A7
RandyJacksonfourcolo
@216.196.97.142:
>
>
> 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
| |
| David W. Fenton 2006-04-06, 9:35 am |
| Randy Jackson < randyjackson@nounsol
icitedfourcolorexplo
sion.com>
wrote in news:Xns979C87430F42
5RandyJacksonfourcol
o@216.196.97.142:
> "David W. Fenton" <XXXusenet@dfenton.com.invalid> wrote in
> news:Xns979C7347175C
Df99a49ed1d0c49c5bbb
2@127.0.0.1:
>
>
> 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/
| |
| Randy Jackson 2006-04-06, 8:29 pm |
|
> 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
| |
| Randy Jackson 2006-04-08, 3:27 am |
| 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
| |
| David W. Fenton 2006-04-08, 9:27 am |
| Randy Jackson < randyjackson@nounsol
icitedfourcolorexplo
sion.com>
wrote in news:Xns979F150D6B74
3RandyJacksonfourcol
o@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/
|
|
|
|
|