473,387 Members | 1,942 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Hidden fields on Microsoft Access

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
Sep 3 '13 #1
3 1455
jimatqsi
1,271 Expert 1GB
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
Sep 3 '13 #2
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
Sep 3 '13 #3
zmbd
5,501 Expert Mod 4TB
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.
Sep 3 '13 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Ryann | last post by:
Hello. I am creating a form that has 5 steps/pages. Each page contains about 20 fields. But I don't want to write them until they submit on the last page. I figured out that I can use hidden...
1
by: mark.reichman | last post by:
First off.. Thanks to Grant Wagner for help in a previous thread related to this one. I am at a total loss... I have multiple fields in a form with the same name. Lets call the fields with the...
4
by: Fred | last post by:
Hi, i know how to pass a value from Javascript to ASP with a hidden field into a form and submitting it, or with cookies, but here i have to pass a lot of data in an array. There is a list of...
10
by: Mark McLellan | last post by:
Dear all Following the oft-repeated advice here and ciwas I have made my site nearly 4.01 strict (working on it). There are some items on which I would appreciate your advice: 1. Hidden...
5
by: NTE | last post by:
Access 2000, My application has a main form that the users interact with. There are 2 hidden fields. When they select "filter by form" from the menu, the hidden fields become visble. Is...
5
by: Roshawn Dawson | last post by:
Hi, Are hidden fields passed in the querystring when a form is posted back? If they are, must the hidden fields be server controls in order to access them from .net code? Thanks, Roshawn
3
by: HockeyFan | last post by:
I know that <input type="hidden" fields are used within a form, but do <ASP:HiddenField s have to be in a form to be used? I've got a VB-based (codebehind) that catches the click event of a button...
5
by: HockeyFan | last post by:
I know that <input type="hidden" fields are used within a form, but do <ASP:HiddenField s have to be in a form to be used? I've got a VB-based (codebehind) that catches the click event of a button...
4
by: minchazo | last post by:
Hello, I've been creating some forms recently in Access 2003 and using hidden textboxes quite a bit. As an example, the visible textbox CasesDone uses the DLookup function to sum the records in...
1
by: DigDag | last post by:
Hi Everyone, this is my first post here. This may sound weird or silly but I have an HTML form and used javascript to validate fields and I use a CGI to process the data. There are hidden fields...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.