Shorten Format Function

[EddyLLC]

Here is an easy one I hope. Is there a way to write this in a shorter format so I don't have to enumerate every @? Some fields are even longer than this one.
Format(rs!ComDescription, "!@@@@@@@@@@@@@@@@@@@@@@@@@")

Thanks

 

[PHV]

Something like this ?
Format(rs!ComDescription, "!" & String(25, "@"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zion7]

I think you mentioned a variance in the length
of the fields, if so, (using PHV's suggestion)...

Dim x as Integer
x = Len(rs!ComDescription)

Format(rs!ComDescription, "!" & String(x, "@"))