Access 2007 Expression help needed

tzinda · tzinda's Computer Specifications

I have a report that has an expression in it that calls for information from a fillin form. The report looks correct in Print Preview but when it is actually printed the output from the expression just shows #Name.
The expression is in a Text box in the Header area of the report.

This is the expression: =" Hours Completed Between " & [Forms]![VRF]![Text1] & " and " & [Forms]![VRF]![Text4]

Any ideas??
Thanks in advance.

tzinda · tzinda's Computer Specifications

Figured it out.

Thanks!

**muckshifter** · muckshifter's Computer Specifications

... well done

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access Form Conditional Formatting Expression Needed	TGV	Microsoft Access	2	19th Jun 2009 06:03 PM
Access 2007 LIKE Expression	kpick4	Microsoft Access Queries	4	29th May 2007 06:00 PM
Access 2007 LIKE Expression	kpick4	Microsoft Access Queries	1	29th May 2007 05:35 PM
Access 2007 LIKE Expression	kpick4	Microsoft Access Queries	0	29th May 2007 04:12 PM
access expression needed	=?Utf-8?B?TVZlbG9jaXR5?=	Microsoft Access Getting Started	5	1st Apr 2006 06:02 PM