Strange unbound control problem
in [Reports]
|
From: swarfmaker on 8 Jul 2008 15:33 Access 2003 on WindowsXP Pro SP2 If I put the following expression into an unbound control: =Trim("Training between "&Format(Now()"d mmmm yyyy")&" & "&Format((Now()+30),"d mmmm yyyy") I get the following result: Between 8 July 2008 & 7 Augu23t 2008 The figures embedded in "August" change every time the report is run. There are no missing references and the database compiles properly. Any ideas? Iain.
From: fredg on 8 Jul 2008 16:23 On Tue, 8 Jul 2008 20:33:46 +0100, swarfmaker wrote: > Access 2003 on WindowsXP Pro SP2 > > If I put the following expression into an unbound control: > =Trim("Training between "&Format(Now()"d mmmm yyyy")&" & > "&Format((Now()+30),"d mmmm yyyy") > > I get the following result: > > Between 8 July 2008 & 7 Augu23t 2008 > > The figures embedded in "August" change every time the report is run. > > There are no missing references and the database compiles properly. > > Any ideas? > > Iain. Why do you need the Trim() function here? You're missing a comma in the first Format argument position. V Format(Now()"d mmmm yyyy") You don't need the extra set of parenthesis in the V V Format((Now()+30), d mmmm yyyy") expression. Now() includes a time value, which you are not using here. Use Date() instead. =Trim("Training between " & Format(Date(),"d mmmm yyyy") & " & " & Format(Date()+30,"d mmmm yyyy")) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
From: KARL DEWEY on 8 Jul 2008 16:25 Try this -- =Trim("Training between " &Format(Date(),"d mmmm yyyy")&" & "&Format((Date()+30),"d mmmm yyyy")) -- KARL DEWEY Build a little - Test a little "swarfmaker" wrote: > Access 2003 on WindowsXP Pro SP2 > > If I put the following expression into an unbound control: > =Trim("Training between "&Format(Now()"d mmmm yyyy")&" & > "&Format((Now()+30),"d mmmm yyyy") > > I get the following result: > > Between 8 July 2008 & 7 Augu23t 2008 > > The figures embedded in "August" change every time the report is run. > > There are no missing references and the database compiles properly. > > Any ideas? > > Iain. > > >
From: swarfmaker on 9 Jul 2008 17:18 "fredg" <fgutkind(a)example.invalid> wrote in message news:1b7l1iaz1dnxu.1l722essub4j0.dlg(a)40tude.net... > On Tue, 8 Jul 2008 20:33:46 +0100, swarfmaker wrote: > >> Access 2003 on WindowsXP Pro SP2 >> >> If I put the following expression into an unbound control: >> =Trim("Training between "&Format(Now()"d mmmm yyyy")&" & >> "&Format((Now()+30),"d mmmm yyyy") >> >> I get the following result: >> >> Between 8 July 2008 & 7 Augu23t 2008 >> >> The figures embedded in "August" change every time the report is run. >> >> There are no missing references and the database compiles properly. >> >> Any ideas? >> >> Iain. > > Why do you need the Trim() function here? > You're missing a comma in the first Format argument position. > V > Format(Now()"d mmmm yyyy") > > You don't need the extra set of parenthesis in the > V V > Format((Now()+30), d mmmm yyyy") expression. > > Now() includes a time value, which you are not using here. > Use Date() instead. > > =Trim("Training between " & Format(Date(),"d mmmm yyyy") & " & " & > Format(Date()+30,"d mmmm yyyy")) > > > -- > Fred > Please respond only to this newsgroup. > I do not reply to personal e-mail I still get the same result with these changes. Also, if I change the & within the Quote marks to "and" that displays the same behaviour i.e. a mixture of letters and numbers. Iain
From: fredg on 9 Jul 2008 20:00
On Wed, 9 Jul 2008 22:18:53 +0100, swarfmaker wrote: > "fredg" <fgutkind(a)example.invalid> wrote in message > news:1b7l1iaz1dnxu.1l722essub4j0.dlg(a)40tude.net... >> On Tue, 8 Jul 2008 20:33:46 +0100, swarfmaker wrote: >> >>> Access 2003 on WindowsXP Pro SP2 >>> >>> If I put the following expression into an unbound control: >>> =Trim("Training between "&Format(Now()"d mmmm yyyy")&" & >>> "&Format((Now()+30),"d mmmm yyyy") >>> >>> I get the following result: >>> >>> Between 8 July 2008 & 7 Augu23t 2008 >>> >>> The figures embedded in "August" change every time the report is run. >>> >>> There are no missing references and the database compiles properly. >>> >>> Any ideas? >>> >>> Iain. >> >> Why do you need the Trim() function here? >> You're missing a comma in the first Format argument position. >> V >> Format(Now()"d mmmm yyyy") >> >> You don't need the extra set of parenthesis in the >> V V >> Format((Now()+30), d mmmm yyyy") expression. >> >> Now() includes a time value, which you are not using here. >> Use Date() instead. >> >> =Trim("Training between " & Format(Date(),"d mmmm yyyy") & " & " & >> Format(Date()+30,"d mmmm yyyy")) >> >> >> -- >> Fred >> Please respond only to this newsgroup. >> I do not reply to personal e-mail > > I still get the same result with these changes. > Also, if I change the & within the Quote marks to "and" that displays the > same behaviour i.e. a mixture of letters and numbers. > > Iain You're telling us what you did, but you're not showing us. Please copy and paste the exact control source expression you are using. Do NOT just re-type it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |