Using my vba function in calculated field ..

[fekrinejat]

How to use user-defined function in a calculated data type in Access 2010
access doesn't recognize my function in expression builder

[RuralGuy]

Your UDF needs to be a Public procedure in a Standard Module that is not named the same as the function.

[fekrinejat]

I usually write my function in module .. as you said my function definition would be something like :

Public Function Test(Entry as Integer) As Integer
Test = Entry * 2
End Function

but access still doesn't recognize my UDF ,

[June7]

As far as I can tell, calculated field type cannot use a UDF.

[RuralGuy]

Are you saying you have a field in a table that is calculated? Why? I would do all my calculations in a query.

[dtours]

A Function (no "Public needed") that you have written in a standard module should show up the query grid using Expression Builder.