Function for Default Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a function I would like to use as a "default value". However, when I
go to the "default value" of the table and place the function in there, it
does not recognize it. So I tried to place the function in the "default
value" of the same field's text box in the form, and it shows nothing (but i
don't get any errors). I then created a new text box and placed the function
in the "control" source (not the "default value" source) and it
works.....What can I do to place the funtion in the "default value" of the
table?

=user()
 
It sems as if my function that I made does not show up in the "default value"
expression builder in the table. All it shows is
built-in-functions....However, in my form I am able to see my created
functions.. I really want to use the function in the table so all new records
recieve the correct "default value" (which is determined by my own created
function)...still confused on this one...any help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default Value in Table 2
Setting default value property in form 1
Table default value question 2
Default Value Function for Modify_Date Field 3
Access Create option group without using wizard? 2
Default Value as last date in a table? 5
default value based on an expression within the table 2
Dmax 2

Back
Top