Hidden fields on Microsoft Access

[e51lrrp]

I have a form for order processing and want to only display the retail price of each item. Not sure how to do this. My query does the computing but I don't want to show the price of the item only the retail price (after markup) How do I do this. Thanks

[jimatqsi]

You'll need to give a lot more information for an informed reply. The simple answer is that you choose which fields to put on the form. Put the ones you want and leave off those you don't want. But I suspect there's more to your question than what the text of it reveals.

You have a form bound to a query, correct?

Jim

[e51lrrp]

you are right Not enough info..I want to calculate in the background a markup for a product but only show the retailprice on the form. The customer will be able to see the form and I want the data person to fill in the price but only have the Retailprice displayed. I have put both fields in the query but when I only display the RetailPrice field it won't let me do anything so I assume (we both know how to spell assume) that I must put both the price and the retail price on the form. What other way can I accomplish this task? Your help is greatly appreciated. S

[zmbd]

You will have to provide the field for the person entering the price on the form to input the data; you can however, in ACC2003 thru current, use the "input mask" for a "password" which you can set to display "*" or "-" or whatever you want. You will find this on the "data" tab of the properties for the contol in form-design view.

Additionally, you can set the forground (font) colours and everything else about the control to match the background of the form, further rendering the value entered "invisible" to the customer.
You will need something for the dataentry person to see or allow the tab-into the control for dataentry.