Textbox replacement?

**Rick Brandt** · Apr 4 '06, 11:15 PM

Re: Textbox replacement?

"Randy Jackson" <randyjackson@n ounsolicitedfou rcolorconsultin g.com> wrote in
message news:Xns979BB50 4626E0RandyJack sonfourcolo@216 .196.97.142...[color=blue]
>
> 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.[/color]

RichText

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

**Randy Jackson** · Apr 4 '06, 11:35 PM

Re: Textbox replacement?

"Rick Brandt" <rickbrandt2@ho tmail.com> wrote in news:6WCYf.4472 4$_S7.39697
@newssvr14.news .prodigy.com:
[color=blue]
> http://www.lebans.com/richtext.htm[/color]

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

--
Randy Jackson

http://fourcolorexplosion.com

**Rick Brandt** · Apr 4 '06, 11:55 PM

Re: Textbox replacement?

"Randy Jackson" <randyjackson@n ounsolicitedfou rcolorexplosion .com> wrote in
message news:Xns979BBA2 562E6DRandyJack sonfourcolo@216 .196.97.142...[color=blue]
> "Rick Brandt" <rickbrandt2@ho tmail.com> wrote in news:6WCYf.4472 4$_S7.39697
> @newssvr14.news .prodigy.com:
>[color=green]
>> http://www.lebans.com/richtext.htm[/color]
>
> I'll check this out, but I'm really looking for a plain text replacement.[/color]

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** · Apr 5 '06, 12:05 AM

Re: Textbox replacement?

Now that's the kind of answer that could make you an MVP.<gd&r>
Congratulations Rick.
:-)
--

HTH
Stephen Lebans

Lebans.com

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Rick Brandt" <rickbrandt2@ho tmail.com> wrote in message
news:6WCYf.4472 4$_S7.39697@new ssvr14.news.pro digy.com...[color=blue]
> "Randy Jackson" <randyjackson@n ounsolicitedfou rcolorconsultin g.com> wrote
> in message news:Xns979BB50 4626E0RandyJack sonfourcolo@216 .196.97.142...[color=green]
>>
>> 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.[/color]
>
>
> 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
>[/color]

**Rick Brandt** · Apr 5 '06, 01:15 AM

Re: Textbox replacement?

"Stephen Lebans" <ForEmailGotoMy .WebSite.-WWWdotlebansdot ...@linvalid.co m> wrote
in message news:7IDYf.5503 3$VV4.949356@ur sa-nb00s0.nbnet.nb .ca...[color=blue]
> Now that's the kind of answer that could make you an MVP.<gd&r>
> Congratulations Rick.
> :-)[/color]

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** · Apr 5 '06, 05:55 AM

Re: Textbox replacement?

"Rick Brandt" <rickbrandt2@ho tmail.com> wrote in
news:azDYf.4473 4$_S7.11174@new ssvr14.news.pro digy.com:
[color=blue]
> Sorry. I misread your original message. What limitation exactly are
> you hitting with the standard TextBox?
>[/color]

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** · Apr 5 '06, 03:35 PM

Re: Textbox replacement?

Randy Jackson <randyjackson@n ounsolicitedfou rcolorexplosion .com>
wrote in news:Xns979C674 218A7RandyJacks onfourcolo@216. 196.97.142:
[color=blue]
> The problem I'm running into is one of text length.[/color]

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** · Apr 5 '06, 06:35 PM

Re: Textbox replacement?

"David W. Fenton" <XXXusenet@dfen ton.com.invalid > wrote in
news:Xns979C734 7175CDf99a49ed1 d0c49c5bbb2@127 .0.0.1:
[color=blue]
> Randy Jackson <randyjackson@n ounsolicitedfou rcolorexplosion .com>
> wrote in news:Xns979C674 218A7RandyJacks onfourcolo@216. 196.97.142:
>[color=green]
>> The problem I'm running into is one of text length.[/color]
>
> 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.
>[/color]

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** · Apr 6 '06, 01:55 PM

Re: Textbox replacement?

Randy Jackson <randyjackson@n ounsolicitedfou rcolorexplosion .com>
wrote in news:Xns979C874 30F425RandyJack sonfourcolo@216 .196.97.142:
[color=blue]
> "David W. Fenton" <XXXusenet@dfen ton.com.invalid > wrote in
> news:Xns979C734 7175CDf99a49ed1 d0c49c5bbb2@127 .0.0.1:
>[color=green]
>> Randy Jackson <randyjackson@n ounsolicitedfou rcolorexplosion .com>
>> wrote in news:Xns979C674 218A7RandyJacks onfourcolo@216. 196.97.142:
>>[color=darkred]
>>> The problem I'm running into is one of text length.[/color]
>>
>> 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.
>>[/color]
>
> I'm not sure I follow. Considering the field is unbound, it
> shouldn't make a difference, right?[/color]

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** · Apr 6 '06, 08:15 PM

Re: Textbox replacement?

[color=blue]
> 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?
>[/color]

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** · Apr 8 '06, 07:15 AM

Re: Textbox replacement?

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** · Apr 8 '06, 02:05 PM

Re: Textbox replacement?

Randy Jackson <randyjackson@n ounsolicitedfou rcolorexplosion .com>
wrote in news:Xns979F150 D6B743RandyJack sonfourcolo@216 .196.97.142:
[color=blue]
> 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.[/color]

???

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/

**Randy Jackson** · Apr 9 '06, 12:25 AM

Re: Textbox replacement?

"David W. Fenton" <XXXusenet@dfen ton.com.invalid > wrote in
news:Xns979F640 8F7BAf99a49ed1d 0c49c5bbb2@127. 0.0.1:
[color=blue]
> Randy Jackson <randyjackson@n ounsolicitedfou rcolorexplosion .com>
> wrote in news:Xns979F150 D6B743RandyJack sonfourcolo@216 .196.97.142:
>
> What background are you coming from that you'd think you needed to
> set the .Text property?
>[/color]

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

Textbox replacement?

Textbox replacement?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment