Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Numeric data in Character field
I have a numeric field that is c(17). It will only have numeric data but I will never perform math on it. It is a DDA (checking account) number. I would like to not show the client leading zeros on the form, but store leading zeros on the database. I would also like to display the number in the textbox shifted to the left, like other numeric fields. Want it to act like a numeric field for the client.
1) How do I not show leading zeros in a textbox when the controlsource is a character field?
2) how can I shift the display in the textbox to the right?
3) in my save routine I do following code. Does this seem OK?
m.dda_disb = RIGHT("00000000000000000" + ALLTRIM(m.dda_disb),17)
if len(alltrim(m.disb_rt_no)) = occurs('0',m.disb_rt_no)
m.dda_disb = ""
endif
Thanks
Brenda
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement