How To Hide A Field In MS Access Form
When we are working with the Access 2016 there are many possibilities of options that we can do. The simplest one, for instance, we can learn to run the easy Access sample by downloading the Access sample database before we try to use it on our own database. The purpose is to avoid the risk of damage on our data from the newly known command on the Ribbon or simply to try the function of the commands in the Access windows. Another easy options we can learn on how to add the object, learning the typical object we can work on in the Access and which object is the suitable one to accommodate our data. Furthermore, we learn also about filtering the information based on the specific filter that we set by making query. Making query can be simple or a little difficult.
If you make a query on one table base, it will me rather easy because the fields you are working in and the filter are all in the same table, let’s say you have a list of customer name and address, you would like to filter them only for those living outside the city and sorter Ascending by the last name. But working with the extra table will need more planning on paper before you jump into the Access window. By using the paper planning you can make a pinpoint of your purpose, used field, where you can find the field and how you want it to link from one to another.
Now we have learn about making filter on Criteria row and Sort row now we will learn on how to hide and show the field. For some data you will need the Zip Code to list up those who are living in the Raleigh city with certain Zip Code, but you will only work on their Email Address and Phone number. So instead of making your eyes misguided with many numbers, you can choose to hide the field of Zip Code by uncheck the checklist box just under the Sort row. The Zip Code criteria will still work on sorting the result, but will be hidden from the final Datasheet view. If you need to unhide it back you can go to the Design view by clicking the View Tab from the Ribbon and choosing the Design View. After that you can click check on the checklist field box and click Run to go to the Datasheet view.
Originally posted 2017-02-25 17:25:01.
Source Tags: hide a field in access table, how to add totals to a query in access, how to add wildcard criteria in access, how to hide a column in access 2013, how to hide a field in access 2016, how to hide a field in access form, how to set total rows to group by in access, stepped layout access.