I use Access only to enter data in a database, and subsequently process them elsewhere.
Somebody was so kind to help me with designing the structure of the database. But then I was on my own and needed to add a number of new variables to one of the tables.
I set Data Type, Description as well as Field Properties (such as Format, Decimal places, Validation Rule) for these new variables in the Design View. All works out fine and the Table shows all the Field Properties as I entered them.
In the large Query that is used to bring data from all Tables together, these new variables are also present. However, the formatting and decimal places for the newly added variables are ignored. Also, in the bottom left of the screen that shows the Query, I do not see the Description of the variable, as I specified in the Table, but only the text "Datasheet View". This is in contrast with the variables that were already present in the table, they are all shown in the Query exactly in the same way as in the Table, including the Description.
Interestingly, if I try to enter new data in the Query for those newly added variables that are outside the permitted range I set in the Field Properties of the Table, the Validation Rule comes in and reports this is not allowed.
So my question is what I can do to make the Query show the appropriate formatting for the new variables, in the way as I have specified in the Table?
Thanks,
Henkie