Help with module format

[edp1959]

How should this look if placed in a module to be called in several places of my database. Just putting it in as is gives me a compile error.

I have defined MyF and Set it depending on which form is running the code, so that is not the problem.

Nz(MyF.T1, " ") & Nz(MyF.T2, " ") & Nz(MyF.T3, " ") & Nz(MyF.T4, " ") & _
Nz(MyF.T5, " ") & Nz(MyF.T6, " ") & Nz(MyF.T7, " ") & Nz(MyF.T8, " ") & _
Nz(MyF.T9, " ") & Nz(MyF.T10, " ") & Nz(MyF.T11, " ") & Nz(MyF.T12, " ") & _
Nz(MyF.T13, " ") & Nz(MyF.T14, " ") & Nz(MyF.T15, " ") & Nz(MyF.T16, " ") & _
Nz(MyF.T17, " ") & Nz(MyF.T18, " ") & Nz(MyF.T19, " ") & Nz(MyF.T20, " ") & _
Nz(MyF.T21, " ") & Nz(MyF.T22, " ") & Nz(MyF.T23, " ") & Nz(MyF.T24, " ") & _
Nz(MyF.T25, " ") & Nz(MyF.T26, " ") & Nz(MyF.T27, " ") & Nz(MyF.T28, " ") & _
Nz(MyF.T29, " ") & Nz(MyF.T30, " ")

 

[Mile-O]

Nz(MyF.T1, " ") & Nz(MyF.T2, " ") & Nz(MyF.T3, " ") & Nz(MyF.T4, " ") & _
Nz(MyF.T5, " ") & Nz(MyF.T6, " ") & Nz(MyF.T7, " ") & Nz(MyF.T8, " ") & _
Nz(MyF.T9, " ") & Nz(MyF.T10, " ") & Nz(MyF.T11, " ") & Nz(MyF.T12, " ") & _
Nz(MyF.T13, " ") & Nz(MyF.T14, " ") & Nz(MyF.T15, " ") & Nz(MyF.T16, " ") & _
Nz(MyF.T17, " ") & Nz(MyF.T18, " ") & Nz(MyF.T19, " ") & Nz(MyF.T20, " ") & _
Nz(MyF.T21, " ") & Nz(MyF.T22, " ") & Nz(MyF.T23, " ") & Nz(MyF.T24, " ") & _
Nz(MyF.T25, " ") & Nz(MyF.T26, " ") & Nz(MyF.T27, " ") & Nz(MyF.T28, " ") & _
Nz(MyF.T29, " ") & Nz(MyF.T30, " ")

That seems an awful lot like you have a design problem over anything else becasue that is one hell of a repeating group.

P.S. You never said what you were really trying to do and that makes no sense on its own.