Can I read the value of a textbox control on a report?

I use A97. I've gotten used to reading values from textbox controls
on forms, I've come to rely on it pretty heavily. My habit spills over
into reports. I'm uncertain whether I can reliably read the values
in textbox controls on reports during the OnFormat event code
the same way I've been doing so in forms.

I have a report I call the 402 report and on it is a LaborCost
textbox. I use a line of code something like this

If txtLaborCost > 0 Then Me!txtLaborCost.Visible = True

in an attempt to read the control's value. I'm not sure I'm getting
what I expect. Who knows about this and feels comfortable
commenting about the topic: Thx.

re: Can I read the value of a textbox control on a report?

Because a report is "built" sequentially, it all depends upon where the
textbox is located and what its control source is -- assuming that we're
talking about code within the report. So, it can be unreliable depending
upon when and where you're trying to read it.

You'll likely have better results if you read the value of the field to
which the textbox is bound.
--

Ken Snell
<MS ACCESS MVP>



"MLH" <CRCI@NorthState.net> wrote in message
news:gnkqs11nlioo43f1i1ekhmgas3403o7t9e@4ax.com...[color=blue]
>I use A97. I've gotten used to reading values from textbox controls
> on forms, I've come to rely on it pretty heavily. My habit spills over
> into reports. I'm uncertain whether I can reliably read the values
> in textbox controls on reports during the OnFormat event code
> the same way I've been doing so in forms.
>
> I have a report I call the 402 report and on it is a LaborCost
> textbox. I use a line of code something like this
>
> If txtLaborCost > 0 Then Me!txtLaborCost.Visible = True
>
> in an attempt to read the control's value. I'm not sure I'm getting
> what I expect. Who knows about this and feels comfortable
> commenting about the topic: Thx.[/color]

re: Can I read the value of a textbox control on a report?

On Wed, 4 Jan 2006 18:55:16 -0500, "Ken Snell"
<kthsneisllis9@ncoomcastt.renaetl> wrote:
[color=blue]
>Because a report is "built" sequentially, it all depends upon where the
>textbox is located and what its control source is -- assuming that we're
>talking about code within the report. So, it can be unreliable depending
>upon when and where you're trying to read it.
>
>You'll likely have better results if you read the value of the field to
>which the textbox is bound.[/color]
Sounds like a plan to me. What syntax do I use to do exactly that?
Obviously, not Me!BlahBlahBlah.

re: Can I read the value of a textbox control on a report?

BTW, my apologies for my system date setting of 1/17/06. Have
corrected now that I've noticed it.

re: Can I read the value of a textbox control on a report?

Me.FieldName

--

Ken Snell
<MS ACCESS MVP>

"MLH" <CRCI@NorthState.net> wrote in message
news:t9oor1lib15tiad64d5j43q9dhv77l0cdh@4ax.com...[color=blue]
> On Wed, 4 Jan 2006 18:55:16 -0500, "Ken Snell"
> <kthsneisllis9@ncoomcastt.renaetl> wrote:
>[color=green]
>>Because a report is "built" sequentially, it all depends upon where the
>>textbox is located and what its control source is -- assuming that we're
>>talking about code within the report. So, it can be unreliable depending
>>upon when and where you're trying to read it.
>>
>>You'll likely have better results if you read the value of the field to
>>which the textbox is bound.[/color]
> Sounds like a plan to me. What syntax do I use to do exactly that?
> Obviously, not Me!BlahBlahBlah.[/color]

re: Can I read the value of a textbox control on a report?

MLH <CRCI@NorthState.net> wrote in
news:gnkqs11nlioo43f1i1ekhmgas3403o7t9e@4ax.com:
[color=blue]
> I use A97. I've gotten used to reading values from textbox controls
> on forms, I've come to rely on it pretty heavily. My habit spills over
> into reports. I'm uncertain whether I can reliably read the values
> in textbox controls on reports during the OnFormat event code
> the same way I've been doing so in forms.
>
> I have a report I call the 402 report and on it is a LaborCost
> textbox. I use a line of code something like this
>
> If txtLaborCost > 0 Then Me!txtLaborCost.Visible = True
>
> in an attempt to read the control's value. I'm not sure I'm getting
> what I expect. Who knows about this and feels comfortable
> commenting about the topic: Thx.
>[/color]

A common way of hiding zero entries is described in help files:

***
Custom Formats
Custom number formats can have one to four sections with semicolons (;)
as the list separator. Each section contains the format specification for
a different type of number.

Section Description
First The format for positive numbers.
Second The format for negative numbers.
Third The format for zero values.
Fourth The format for Null values.


For example, you could use the following custom Currency format:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
***

To hide zero we might specifiy

$#,##0.00[Green];($#,##0.00)[Red];"";""

This might be simpler, perhaps even safer then setting the visiblity of
the textbox in code.


--
Lyle Fairfield

re: Can I read the value of a textbox control on a report?

In Google my response seems to be a response to Ken Snell's second
contribution to this thread. Actually it's a direct reponse to MLH's
original post, which doesn't show in Google.

re: Can I read the value of a textbox control on a report?

MLH wrote:[color=blue]
> I use A97. I've gotten used to reading values from textbox controls
> on forms, I've come to rely on it pretty heavily. My habit spills over
> into reports. I'm uncertain whether I can reliably read the values
> in textbox controls on reports during the OnFormat event code
> the same way I've been doing so in forms.
>
> I have a report I call the 402 report and on it is a LaborCost
> textbox. I use a line of code something like this
>
> If txtLaborCost > 0 Then Me!txtLaborCost.Visible = True
>
> in an attempt to read the control's value. I'm not sure I'm getting
> what I expect. Who knows about this and feels comfortable
> commenting about the topic: Thx.[/color]

From experience, I can tell you that it is common and reliable to read
text box values in Format events on reports. You can safely access the
value of any control in the section/instance being formatted, or in the
header or footer of any section it is contained within. You can read
footer control values even though the footer will be printed after the
section/instance being formatted because the control's value has already
been determined, even though the formatting to display it might not be.

re: Can I read the value of a textbox control on a report?

On Wed, 4 Jan 2006 20:28:51 -0500, "Ken Snell"
<kthsneisllis9@ncoomcastt.renaetl> wrote:
[color=blue]
>Me.FieldName[/color]
Thx much, Ken.

re: Can I read the value of a textbox control on a report?

[color=blue]
> From experience, I can tell you that it is common and reliable to read
>text box values in Format events on reports. You can safely access the
>value of any control in the section/instance being formatted, or in the
>header or footer of any section it is contained within. You can read
>footer control values even though the footer will be printed after the
>section/instance being formatted because the control's value has already
>been determined, even though the formatting to display it might not be.[/color]
Thx Steve. I'm glad to hear someone confirm this. I make assumptions
that are wrong all the time. I'd done a fair amount of testing on this
topic, but I hadn't convinced myself that was entirely reliable. Thx
for helping out.

re: Can I read the value of a textbox control on a report?

"Steve Jorgensen" <nospam@nospam.nospam> wrote in message
news:NpadnW1Kc8WKNCHenZ2dnUVZ_tednZ2d@comcast.com. ..[color=blue]
> MLH wrote:[color=green]
> > I use A97. I've gotten used to reading values from textbox controls
> > on forms, I've come to rely on it pretty heavily. My habit spills over
> > into reports. I'm uncertain whether I can reliably read the values
> > in textbox controls on reports during the OnFormat event code
> > the same way I've been doing so in forms.
> >
> > I have a report I call the 402 report and on it is a LaborCost
> > textbox. I use a line of code something like this
> >
> > If txtLaborCost > 0 Then Me!txtLaborCost.Visible = True
> >
> > in an attempt to read the control's value. I'm not sure I'm getting
> > what I expect. Who knows about this and feels comfortable
> > commenting about the topic: Thx.[/color]
>
> From experience, I can tell you that it is common and reliable to read
> text box values in Format events on reports. You can safely access the
> value of any control in the section/instance being formatted, or in the
> header or footer of any section it is contained within. You can read
> footer control values even though the footer will be printed after the
> section/instance being formatted because the control's value has already
> been determined, even though the formatting to display it might not be.[/color]

Does the "On Format" event fire each time the page is viewed? I would think
you could have a problem if the user paged up and down causing repeated
updates from the control.

re: Can I read the value of a textbox control on a report?

paii, Ron wrote:[color=blue]
> "Steve Jorgensen" <nospam@nospam.nospam> wrote in message
> news:NpadnW1Kc8WKNCHenZ2dnUVZ_tednZ2d@comcast.com. ..
>[color=green]
>>MLH wrote:
>>[color=darkred]
>>>I use A97. I've gotten used to reading values from textbox controls
>>>on forms, I've come to rely on it pretty heavily. My habit spills over
>>>into reports. I'm uncertain whether I can reliably read the values
>>>in textbox controls on reports during the OnFormat event code
>>>the same way I've been doing so in forms.
>>>
>>>I have a report I call the 402 report and on it is a LaborCost
>>>textbox. I use a line of code something like this
>>>
>>>If txtLaborCost > 0 Then Me!txtLaborCost.Visible = True
>>>
>>>in an attempt to read the control's value. I'm not sure I'm getting
>>>what I expect. Who knows about this and feels comfortable
>>>commenting about the topic: Thx.[/color]
>>
>> From experience, I can tell you that it is common and reliable to read
>>text box values in Format events on reports. You can safely access the
>>value of any control in the section/instance being formatted, or in the
>>header or footer of any section it is contained within. You can read
>>footer control values even though the footer will be printed after the
>>section/instance being formatted because the control's value has already
>>been determined, even though the formatting to display it might not be.[/color]
>
>
> Does the "On Format" event fire each time the page is viewed? I would think
> you could have a problem if the user paged up and down causing repeated
> updates from the control.
>
>[/color]

It is not predictable when Format will fire, how many times, or in what
order. It's OK though, so long as your code does not do anything that
should care. If you need a counter, for instance, use a running sum
contol with a Control Source of =1 rather than using a counter in code
because accuracy of the the running sum will be maintaned for us by Access.

re: Can I read the value of a textbox control on a report?

Steve Jorgensen <nospam@nospam.nospam> wrote in
news:irCdneflnf01BSDeRVn-sA@comcast.com:
[color=blue]
> paii, Ron wrote:[color=green]
>> "Steve Jorgensen" <nospam@nospam.nospam> wrote in message
>> news:NpadnW1Kc8WKNCHenZ2dnUVZ_tednZ2d@comcast.com. ..
>>[color=darkred]
>>>MLH wrote:
>>>
>>>>I use A97. I've gotten used to reading values from textbox
>>>>controls on forms, I've come to rely on it pretty heavily.
>>>>My habit spills over into reports. I'm uncertain whether I
>>>>can reliably read the values in textbox controls on reports
>>>>during the OnFormat event code the same way I've been doing
>>>>so in forms.
>>>>
>>>>I have a report I call the 402 report and on it is a
>>>>LaborCost textbox. I use a line of code something like this
>>>>
>>>>If txtLaborCost > 0 Then Me!txtLaborCost.Visible = True
>>>>
>>>>in an attempt to read the control's value. I'm not sure I'm
>>>>getting what I expect. Who knows about this and feels
>>>>comfortable commenting about the topic: Thx.
>>>
>>> From experience, I can tell you that it is common and
>>> reliable to read
>>>text box values in Format events on reports. You can safely
>>>access the value of any control in the section/instance being
>>>formatted, or in the header or footer of any section it is
>>>contained within. You can read footer control values even
>>>though the footer will be printed after the section/instance
>>>being formatted because the control's value has already been
>>>determined, even though the formatting to display it might
>>>not be.[/color]
>>
>>
>> Does the "On Format" event fire each time the page is viewed?
>> I would think you could have a problem if the user paged up
>> and down causing repeated updates from the control.
>>
>>[/color]
>
> It is not predictable when Format will fire, how many times,
> or in what order. It's OK though, so long as your code does
> not do anything that should care. If you need a counter, for
> instance, use a running sum contol with a Control Source of =1
> rather than using a counter in code because accuracy of the
> the running sum will be maintaned for us by Access.
>[/color]
The On Retreat event fires when paging up, and I've used it
successfully to maintain counter accuracy.

--
Bob Quintal

PA is y I've altered my email address.

re: Can I read the value of a textbox control on a report?

Bob Quintal wrote:[color=blue]
> Steve Jorgensen <nospam@nospam.nospam> wrote in
> news:irCdneflnf01BSDeRVn-sA@comcast.com:
>
>[color=green]
>>paii, Ron wrote:
>>[color=darkred]
>>>"Steve Jorgensen" <nospam@nospam.nospam> wrote in message
>>>news:NpadnW1Kc8WKNCHenZ2dnUVZ_tednZ2d@comcast.c om...
>>>
>>>
>>>>MLH wrote:
>>>>
>>>>
>>>>>I use A97. I've gotten used to reading values from textbox
>>>>>controls on forms, I've come to rely on it pretty heavily.
>>>>>My habit spills over into reports. I'm uncertain whether I
>>>>>can reliably read the values in textbox controls on reports
>>>>>during the OnFormat event code the same way I've been doing
>>>>>so in forms.
>>>>>
>>>>>I have a report I call the 402 report and on it is a
>>>>>LaborCost textbox. I use a line of code something like this
>>>>>
>>>>>If txtLaborCost > 0 Then Me!txtLaborCost.Visible = True
>>>>>
>>>>>in an attempt to read the control's value. I'm not sure I'm
>>>>>getting what I expect. Who knows about this and feels
>>>>>comfortable commenting about the topic: Thx.
>>>>
>>>>From experience, I can tell you that it is common and
>>>>reliable to read
>>>>text box values in Format events on reports. You can safely
>>>>access the value of any control in the section/instance being
>>>>formatted, or in the header or footer of any section it is
>>>>contained within. You can read footer control values even
>>>>though the footer will be printed after the section/instance
>>>>being formatted because the control's value has already been
>>>>determined, even though the formatting to display it might
>>>>not be.
>>>
>>>
>>>Does the "On Format" event fire each time the page is viewed?
>>>I would think you could have a problem if the user paged up
>>>and down causing repeated updates from the control.
>>>
>>>[/color]
>>
>>It is not predictable when Format will fire, how many times,
>>or in what order. It's OK though, so long as your code does
>>not do anything that should care. If you need a counter, for
>>instance, use a running sum contol with a Control Source of =1
>>rather than using a counter in code because accuracy of the
>>the running sum will be maintaned for us by Access.
>>[/color]
>
> The On Retreat event fires when paging up, and I've used it
> successfully to maintain counter accuracy.
>[/color]

Sure, but why do that? It's hard to know that you've covered all the
cases correctly, dealt with what happens whenyou print from preview,
etc. It's much easeir to make code that doesn't need to keep track of
the order of events than to track of the order accurately.

re: Can I read the value of a textbox control on a report?

Shouldn't be a prob for me. All I'm doing
is setting visible property on a textbox.
Paging through records - some are shown,
some are not. Just depends on the value
in the control.