I have a report, which prints #Name, if the user doesn't select a time frame prior to opening the report

The textbox control source is: ="Covers " & [Forms]![TimeFrame]![tBeginDate] & " to " & [Forms]![TimeFrame]![tEndDate]

Could I put, some kind of iff statement, for example iff Forms!TimeFrame null or "", please select a time frame? I tried a few different syntax which errored out, help

try these:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46843
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46833