PC Review


Reply
Thread Tools Rate Thread

Access 2007 Expression help needed

 
 
New Member
Join Date: May 2010
Posts: 2
 
      6th May 2010
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.
 
Reply With Quote
 
 
 
 
New Member
Join Date: May 2010
Posts: 2
 
      7th May 2010
Figured it out.

Thanks!
 
Reply With Quote
 
Captain Crunchie, Retired
muckshifter's Avatar
Join Date: Mar 2002
Location: In a Hovel
Posts: 19,977
 
      8th May 2010
... well done



 
I'm not grouchy by nature, it takes constant effort.



Flickr

Every day I beat my own previous record for number of consecutive days I've stayed alive.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:51 PM.