By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

When can we give control source of a textbox=1?

P: 1
When can we give control source of a textbox =1?
Nov 21 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
When can we give control source of a textbox =1?
Control Source of the textbox is:

1. The field to which it is bound when the form is bound to a table or query
2. In an unbound textbox the control source can be set to =1 but this will make the value 1 for every record and won't store the value anywhere.

You may be looking for something called default value.

a) Set the Control Source to the field you want to store the value in as normal
b) Set the default value =1

This will default this field value to 1 for all new records. However, it won't work on existing records.
Nov 21 '06 #2

Post your reply

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