By default, a field in a query inherits all the properties that it has in the underlying table or query. For example, if you've set the Format property of an OrderDate field to Medium Date, the OrderDate field is formatted in the query results as Medium Date. Only the field properties you can change are displayed on a field's property sheet in a query.
If you change a field property in table Design view, any new or existing query automatically inherits the change unless you previously changed that property in query Design view. Settings you change in query Design view aren't affected by subsequent changes in table Design view, nor is table Design view affected by the changes you make to the properties in query Design view.
Because calculated fields display data that isn't stored in any table, they don't inherit table properties. For example, your query might include a field that calculates a currency value, but the values in this field aren't displayed in currency format unless you set the Format property for this field to Currency.
When you create a form or report based on a query, the form or report fields take on the field properties you've set in the query or underlying table. If you subsequently change the property setting for a control in the form or report, the change doesn't affect the setting of that property for the field in the underlying query. Likewise, if you change the property setting for a field in a query after you've created a form using that field, the property setting for the control isn't updated; you must update this manually.