Re: A more elegant solution?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This is easy. Put a lable or text box on the form, put (name).caption or (name).text where name is something like lblFormVariable or txtFormVariable etc (depending on which you use), then make the label or text box hidden by default so set visible to false.

This should solve the problem : )

"Bob Quintal" <rquintal@xxxxxxxxxxxxx> wrote in message news:Xns99669CAFCE9E3BQuintal@xxxxxxxxxxxxxxxx
"Laurel" <FakeMail@xxxxxxxxxxx> wrote in
news:#Rgn0jMwHHA.1204@xxxxxxxxxxxxxxxxxxxx:

I often want to display the value of a global variable in a
form or report. I need to do this via a function (can't just
display the variable itself, it seems). Instead of a bunch of
specific functions, I'd like to have a single
"fncDisplayGlobal()" function. I could create one with an
ever-growing SELECT statement in it, but is there a more
elegant way? Can I somehow pass in the name of the function
as a string and then magically turn it into the variable of
the same name? And then pass back the value?

why go to all that trouble. Just put a label on the form or report
and put the following code into the logical event
me.label.caption = variable.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com


.

Relevant Pages

  • Re: make field invisable
    ... when I go to the EVENT tab of the detail section of the report (which ... or show depending on the checkbox being checked or not (all 11 ... the fields that make up the 1st label are: ...
    (microsoft.public.access.formscoding)
  • Resizing of field on a report.
    ... I have a report (label) that has one particular field on it that depending ... In other words for the record that has only 3 lines of text that the font be ...
    (microsoft.public.access.forms)
  • Derive Report Column Label from Query result
    ... Depending on how the report is run, ... label containing what I would want to see as ... point to it's own query which would return the label text I'd want to see on ...
    (microsoft.public.access.reports)
  • Re: Fields in Label dont give correct information
    ... tables where the data was stored in the query the query would not run. ... half the time with very few errors (other than that label problem I had.) ... report all of the information shows up on the report the way I want it to. ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)