Function for Default Value

J

JJ

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()
 
J

JJ

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.
 
Top