View Single Post
  #1  
Old March 24th, 2010, 06:11 PM posted to microsoft.public.access
Scafidel[_3_]
external usenet poster
 
Posts: 11
Default Fixed field characters

I am filling a bank draft field with this code in Expression Builder and
would like it to always fill with "*" to the end whether it is "TEN DOLLARS"
or "FIVE THOUSAND FOUR HUNDRED AND FOURTEEN DOLLARS AND FIFTY CENTS." How
can I do this without always editing the end document?

=("*" & Num2Text([TB],3) & "***********************")

--
Lafayette, LA