Footer formatting, custom?

[StargateFan]

I have modified the standard footer created in a report so that the 2
elements are all in one:

=Now() & " Page " & [Page] & " of " & [Pages]


I figured out a few days ago how to get =Now() by itself to give me
the date/time format that I use all the time by putting this in the
format:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

The above gives me the style of Sat.Dec.31.2005; 10h59 no matter what
the region settings are on any given pc. These 2 things good so far,
as far as they go.

Because I couldn't seem to get the separate =Now() and Page x of y
fields close enough to display properly, I put them together as the
first line shows above. My question is, is there a way to format

=Now() & " Page " & [Page] & " of " & [Pages]

so that it, too, returns:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

for the date/time part?

The Page x of y doesn't have anything in the format line (3rd line
down under the "All" tab in the properties for the Page x of y
control). If it did, I could just have added the ddd... line above to
it.

Thank you for any help! D

 

[Douglas J. Steele]

=Format(Now(), "ddd\.mmm\.dd\.yyyy\; "hh\hnn") & " Page " & [Page] &
" of " & [Pages]

 

[StargateFan]

=Format(Now(), "ddd\.mmm\.dd\.yyyy\; "hh\hnn") & " Page " & [Page] &
" of " & [Pages]

Hi, thank you.

This didn't work and in fact didn't change anything, so I know I'm
doing something wrong. In the control source box I have:
=Now() & " Page " & [Page] & " of " & [Pages]

I put your above line of code into the format box below the control
source box in the properties (without the wordwrap, of course<g>).

Should I be doing something different? The footer looks the same with
or without the
=Format(Now(), "ddd\.mmm\.dd\.yyyy\; ... line above.

Thank you! D

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have modified the standard footer created in a report so that the 2
elements are all in one:

=Now() & " Page " & [Page] & " of " & [Pages]


I figured out a few days ago how to get =Now() by itself to give me
the date/time format that I use all the time by putting this in the
format:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

The above gives me the style of Sat.Dec.31.2005; 10h59 no matter what
the region settings are on any given pc. These 2 things good so far,
as far as they go.

Because I couldn't seem to get the separate =Now() and Page x of y
fields close enough to display properly, I put them together as the
first line shows above. My question is, is there a way to format

=Now() & " Page " & [Page] & " of " & [Pages]

so that it, too, returns:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

for the date/time part?

The Page x of y doesn't have anything in the format line (3rd line
down under the "All" tab in the properties for the Page x of y
control). If it did, I could just have added the ddd... line above to
it.

Thank you for any help! D

 

[StargateFan]

=Format(Now(), "ddd\.mmm\.dd\.yyyy\; "hh\hnn") & " Page " & [Page] &
" of " & [Pages]

Hi, thank you.

This didn't work and in fact didn't change anything, so I know I'm
doing something wrong. In the control source box I have:
=Now() & " Page " & [Page] & " of " & [Pages]

I put your above line of code into the format box below the control
source box in the properties (without the wordwrap, of course<g>).

Should I be doing something different? The footer looks the same with
or without the
=Format(Now(), "ddd\.mmm\.dd\.yyyy\; ... line above.

Thank you! D

(Oops, p.s., should say that I'm using A2K. Don't know if that makes
a difference.)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have modified the standard footer created in a report so that the 2
elements are all in one:

=Now() & " Page " & [Page] & " of " & [Pages]


I figured out a few days ago how to get =Now() by itself to give me
the date/time format that I use all the time by putting this in the
format:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

The above gives me the style of Sat.Dec.31.2005; 10h59 no matter what
the region settings are on any given pc. These 2 things good so far,
as far as they go.

Because I couldn't seem to get the separate =Now() and Page x of y
fields close enough to display properly, I put them together as the
first line shows above. My question is, is there a way to format

=Now() & " Page " & [Page] & " of " & [Pages]

so that it, too, returns:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

for the date/time part?

The Page x of y doesn't have anything in the format line (3rd line
down under the "All" tab in the properties for the Page x of y
control). If it did, I could just have added the ddd... line above to
it.

Thank you for any help! D

 

[fredg]

=Format(Now(), "ddd\.mmm\.dd\.yyyy\; "hh\hnn") & " Page " & [Page] &
" of " & [Pages]

Hi, thank you.

This didn't work and in fact didn't change anything, so I know I'm
doing something wrong. In the control source box I have:
=Now() & " Page " & [Page] & " of " & [Pages]

I put your above line of code into the format box below the control
source box in the properties (without the wordwrap, of course<g>).

Should I be doing something different? The footer looks the same with
or without the
=Format(Now(), "ddd\.mmm\.dd\.yyyy\; ... line above.

Thank you! D

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have modified the standard footer created in a report so that the 2
elements are all in one:

=Now() & " Page " & [Page] & " of " & [Pages]


I figured out a few days ago how to get =Now() by itself to give me
the date/time format that I use all the time by putting this in the
format:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

The above gives me the style of Sat.Dec.31.2005; 10h59 no matter what
the region settings are on any given pc. These 2 things good so far,
as far as they go.

Because I couldn't seem to get the separate =Now() and Page x of y
fields close enough to display properly, I put them together as the
first line shows above. My question is, is there a way to format

=Now() & " Page " & [Page] & " of " & [Pages]

so that it, too, returns:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

for the date/time part?

The Page x of y doesn't have anything in the format line (3rd line
down under the "All" tab in the properties for the Page x of y
control). If it did, I could just have added the ddd... line above to
it.

Thank you for any help! D

You miss understood Doug's reply.
His expression goes in place of your control source, not in addition
to it.
Delete any Format property you may still have in this control.
Delete the Input Mask property (which appears to be where you placed
his code).
In the Control Source property write his expression, all on one line.

 

[StargateFan]

=Format(Now(), "ddd\.mmm\.dd\.yyyy\; "hh\hnn") & " Page " & [Page] &
" of " & [Pages]

Hi, thank you.

This didn't work and in fact didn't change anything, so I know I'm
doing something wrong. In the control source box I have:
=Now() & " Page " & [Page] & " of " & [Pages]

I put your above line of code into the format box below the control
source box in the properties (without the wordwrap, of course<g>).

Should I be doing something different? The footer looks the same with
or without the
=Format(Now(), "ddd\.mmm\.dd\.yyyy\; ... line above.

Thank you! D

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



I have modified the standard footer created in a report so that the 2
elements are all in one:

=Now() & " Page " & [Page] & " of " & [Pages]


I figured out a few days ago how to get =Now() by itself to give me
the date/time format that I use all the time by putting this in the
format:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

The above gives me the style of Sat.Dec.31.2005; 10h59 no matter what
the region settings are on any given pc. These 2 things good so far,
as far as they go.

Because I couldn't seem to get the separate =Now() and Page x of y
fields close enough to display properly, I put them together as the
first line shows above. My question is, is there a way to format

=Now() & " Page " & [Page] & " of " & [Pages]

so that it, too, returns:

ddd\.mmm\.dd\.yyyy"; "hh\hnn

for the date/time part?

The Page x of y doesn't have anything in the format line (3rd line
down under the "All" tab in the properties for the Page x of y
control). If it did, I could just have added the ddd... line above to
it.

Thank you for any help! D

You miss understood Doug's reply.
His expression goes in place of your control source, not in addition
to it.
Delete any Format property you may still have in this control.
Delete the Input Mask property (which appears to be where you placed
his code).
In the Control Source property write his expression, all on one line.

No, sorry it wasn't clear but I didn't misunderstand. I tried both
ways and in every controlsource box in the properties there is.
Nothing happens. There must be something I'm missing, that's what I
meant.

I'll keep plugging away. I'm going to try something now to see if it
works. Yup, I'm missing something big time ...

 

[StargateFan]

Okay, I'm obviously making a bigger muddle of this than it needs to
be. Trying again today I see that I'm not resolving the problem, so
going to wipe the slate clean. It seems I just don't have the skills
yet to modify the footer and I'm obviously not asking for the right
thing in the archives. Just like in FMP, the expression builder is
beyond me as yet, too <sigh>.

So, what it boils down to is how can I get this end result in all my
footers in all my reports without using 2 boxes, i.e., like the
defaults Now() and Page x of y boxes - just all in one:



Sun.Jan.01.2006; 10h14 Page 1 of 2



Thanks! Have to know when to throw in the towel ... <g>.

 

[Rick Brandt]

Okay, I'm obviously making a bigger muddle of this than it needs to
be. Trying again today I see that I'm not resolving the problem, so
going to wipe the slate clean. It seems I just don't have the skills
yet to modify the footer and I'm obviously not asking for the right
thing in the archives. Just like in FMP, the expression builder is
beyond me as yet, too <sigh>.

So, what it boils down to is how can I get this end result in all my
footers in all my reports without using 2 boxes, i.e., like the
defaults Now() and Page x of y boxes - just all in one:

Sun.Jan.01.2006; 10h14 Page 1 of 2

Thanks! Have to know when to throw in the towel ... <g>.

I just copied this from the ControlSource of a TextBox that DOES give the result
you are asking for...

=Format(Now(),"ddd\.mmm\.dd\.yyyy""; ""hh\hnn") & " Page " & [Page] & "
of " & [Pages]

 

[StargateFan]

Okay, I'm obviously making a bigger muddle of this than it needs to
be. Trying again today I see that I'm not resolving the problem, so
going to wipe the slate clean. It seems I just don't have the skills
yet to modify the footer and I'm obviously not asking for the right
thing in the archives. Just like in FMP, the expression builder is
beyond me as yet, too <sigh>.

So, what it boils down to is how can I get this end result in all my
footers in all my reports without using 2 boxes, i.e., like the
defaults Now() and Page x of y boxes - just all in one:

Sun.Jan.01.2006; 10h14 Page 1 of 2

Thanks! Have to know when to throw in the towel ... <g>.

I just copied this from the ControlSource of a TextBox that DOES give the result
you are asking for...

=Format(Now(),"ddd\.mmm\.dd\.yyyy""; ""hh\hnn") & " Page " & [Page] & "
of " & [Pages]

Okay, I see where I've gone wrong, I think. The trick is to just do
this from scratch. I, too, got the right results just now. But this
time, I deleted all the boxes that were in the footer and created an
unbound text box and then put the above into the controlsource of its
properties.

That was what was wrong, I'm guessing, to try to just modify the
existing footer <g>. Thankfully, learned about unbound text boxes
this week ... <g>

Thanks! D