Conditional formatting and others

[fathyano]

1. I have a database where there is a field with a date formate, how can I make conditional formatting to this filed where the dates of TOMORROW- IN THE FORM VIEW- is colored by ....,YESTERDAY colored by ... and TODAY colored by ...., is this possible??
2. Another question, when I export the form to PDF (form view) I find the last part of the first page is the first part of the second page, and the last part of the seond page is the first part of the third page, etc......... I want each page in the form is in a single page in the PDF (single page not single file), HOW CAN I DO THAT??
3. Third question, I have two forms, first one is for all the transactions with the date of each one, second one is for all the actions occured. The transactions and its dates is a filed in the general form (actions in general). I want to link the two tables with a relation, so that the LAST transaction (took place yesterday or today or at any date) is the only one to be viewed in this form, considering that every day or every few days a transation added to the transactions table, so I want to say to the form of the actions: read always the last recorded transaction only.

 

[DCrake]

First ask questions 1 at a time. This approach will only lead to members ignoring the post as you are asking too many things at once.

To answer your first question, yes you can, have a look at conditional formatting.

David