Question Why Date works in one report but not another

[Stoss]

I have two reports that are fairly similar. In both I used

Me!txtMyCaption = strLocation & "'s " & "Priority Report as of " & Date
(same name in both reports)


It works fine in one report but not the other. In the one that doesn't work, it prints all the text you see above except the date. I am setting this on the Activate Event in both.

Now() works fine in both

Confused,
-Stoss

 

[RuralGuy]

Import the db into a fresh new db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

 

[Mr Smin]

I normally get an error if *any* part of a text box fails - any chance that it's as simple as not enough room in the box to display the date?

 

[vbaInet]

Also try one of three things, in order of preference:

1. Use the Load event instead of the Activate event

OR

2. Me!txtMyCaption = strLocation & "'s " & "Priority Report as of " & VBA.Date

OR

3. Me!txtMyCaption = strLocation & "'s " & "Priority Report as of " & DateValue(Now())

 

[reddwarf]

seems simple but its DATE() or NOW() - you are bracketing both right ?

 

[boblarson]

seems simple but its DATE() or NOW() - you are bracketing both right ?

You don't use the parens in VBA. In queries and control sources - yes, but VBA - no.

 

[boblarson]

You don't use the parens in VBA. In queries and control sources - yes, but VBA - no.

Although if you use VBA.Date() you CAN use the parens in VBA.

 

[vbaInet]

The brackets are optional in VBA.

 

[boblarson]

The brackets are optional in VBA.

Optional if you use VBA.Date, but if you just use DATE it will strip them even if you include them. (and they are parentheses not brackets - there is a difference )

 

[vbaInet]

Yep, that's right, which is why I mentioned about it being optional. Whether you put it or not, it will strip it off. It's still a good habit to put them.

 

[vbaInet]

(and they are parentheses not brackets - there is a difference )

In the right sense of the word, yes they are parentheses

 

[Rabbie]

In the right sense of the word, yes they are parentheses

Glad we got that settled then