Setting value of a text box on a report from VBA code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 19 May 2005 16:00 GMT

Good Morning,

I have created a coversheet and would like to add a date field. I have an
input box to enter the day to be displayed, but I'm having trouble setting
the text box value to the date supplied.

I'm sorry this is so vague, please let me know what information you need to
answer this issue.

Thank you,
Dan

Reply to this Message

Margaret Bartley - 24 May 2005 22:55 GMT

I'm not sure where your input box is. Is it on a form? If so,
you can reference it like any other data source:
=forms!MyForm!txtInput

> Good Morning,
>
> I have created a coversheet and would like to add a date field. I have an
> input box to enter the day to be displayed, but I'm having trouble setting
> the text box value to the date supplied.

Reply to this Message

Dan - 25 May 2005 13:41 GMT

I have a input box popup, but I can't get the value from the input box to
carry over to the form.

> I'm not sure where your input box is. Is it on a form? If so,
> you can reference it like any other data source:
[quoted text clipped - 5 lines]
> > input box to enter the day to be displayed, but I'm having trouble setting
> > the text box value to the date supplied.

Reply to this Message

Margaret Bartley - 31 May 2005 22:52 GMT

That's why I asked where the input box was. If it is in your report, you
will have to put a global variable in your report, and reference it in the
OnFormat action of whichever section the data will be in. If the input box
is called from a form, you would put the result in a text box on your form,
and reference that .

In any event, you need to have a variable to hold the value, and then
reference that variable in your report.

>I have a input box popup, but I can't get the value from the input box to
> carry over to the form.
[quoted text clipped - 10 lines]
>> > setting
>> > the text box value to the date supplied.

Reply to this Message