Format datasheets
In Access the appearance of standard data sheets is white and gray lines, but you do not like the normal aspect, we can change the look as follows:
- After opening the data sheet you want to change go to the Format menu and choose Data Sheets.
- You will see the table formatting datasheets. In the first option have the effect of the cells, which may be flat, raised and sunken. The last two options only allow us to obtain an aspect of high or low relief and we can not choose anything else, the option plan that is able to choose more effects.
- The second option is Gridlines which allows us to choose whether you want the vertical or horizontal lines active or not.
- Background Color: as the name suggests is to choose the color of the cells just choose one from the list.
- Color of grid lines: the same function as in the preceding paragraph but for the grid lines.
- Border styles and line: change the appearance of gridlines, underline the column header and the border style of the data sheet. In the left list choose the line you want to change and list on the right line style.
- Direction: here we can change how the fields are presented in terms of order, we have the normal direction is from left to right or we can choose from right to left which will change the order of the fields and pull the right part Data Sheet. What we can see in figure 2. Note: this change can only be done on tables and not on data sheets on the forms.
Picture1: 
Picture 2:
Best regards
I wanted to format the date in a report to print a report in check, but that is date type spaces (2 0 0 8 0 6 0 1). which character should I enter in the numbers, not to miss the date?
thanks
Hello Jacinto,
To do this you must create a new text field with the following expression:
= Format ([if the date field], "mm dd yyyy")
and properties of the field put the following words in the input mask: 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0
Any doubt tell, but I will still provide an example.
[...] Reader Jacinto put a question here on how to change the format of a date of 12/06/2008 for 2 0 0 8 0 6 1 2, the [...]
Good days
He needed help.
There is a field in my database that wanted to appear in reports and forms in a different color according to their output. It is a field "activity status". If the state was "Why start" appear in red. If it was "In Progress" appear in orange. If the status was "Completed" appear in green. Anyone know how can I implement this?
I am waiting for help.
Regards,
Milton Aguiar
Good Afternoon.
If you get a response about their doubts, I wish that you share with me because I have the same doubt!
Thank you.
hello good afternoon wanted to know a way to get the system date and takes you 100 years. will be possible?
I think seia more or less like this:
= Systemdate Systemdate-100 years
hello good afternoon wanted to know a way to get the system date and takes you 100 years. will be possible?
I think seia more or less like this:
= Systemdate Systemdate-100 years.
I've been already searching the net a lot of time and I have sql books and still can not ...
thank to help me ...
Stay well
It's easy, with this command:
= DateAdd ("yyyy", -100, Date ())
This command takes 100 years to the current date.
A program for incoming mail with automatic numbering of entry, as I do that on day 1 of each year is restarted with the entry number one, keeping the previous year?
In a program input correspondence with automatic numbering, how to at the beginning of each year to restart in a number