Marking the latest record on a continuous form

  • Thread starter Thread starter manningfan
  • Start date Start date
M

manningfan

I'm not sure how to word this, but what I want to do is show a
continuous form and have a line that is on the form become visible ONLY
under the latest record, similar to what Quicken does if you've ever
post-dated a check using it. Is this even possible? My database has
dates in the past as well as the future and I'd like to show the
distinction between them if possible.

Any help would be greatly appreciated.
 
Open the form in design view and ensure that you can see the form footer.
Place a line (it's on the toolbox) at the top of the form footer. Set the
thickness of the line to what you want. This will draw a line under the last
record.

You can't use this to e mail reports RFT format (for word) - you will need
to include a String for this as your line.
 
I have done this by making the background of all my fields invisible and
placing the criteria field (the date in your case behind them. You can do
this by adding the new date field, deleting the original fields and pasting
them back. Make the new date field as tall and as wide as line of fields and
setting the background to white and the text to white. Then set the
conditional formatting (Format, Conditional formatting) on the new date field
to whatever you want. You have to set the background and the text to the
same color. Remember to make sure that the text in your fields contrasts
with the new background.
Hope this helps,
Bob
 
Back
Top