var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: update text field
Sorry, I'm pretty newbie. I have a numeric field that needs to update to a new table. In the new table the field has to be text and zero filled. I tried everything on mask but didn't work. Can someone help?
Why do you have to do that?
Could you not change the target table's datatype to number and apply display masks when necessary?
I need a 7 byte only output and the data needs to export as '0000123'
You CAN parse your number into a string yes, I understand your question.
That doesn't seem like a logistically sound thing to do..?
I don't know why you would do this, but here's a crude function you could use:
Public Function IntToStr(IntValue As String) As String
Dim s As String
Dim i As Integer
For i = 1 To (7 - Len(IntValue))
s = s & "0"
s = s & IntValue
IntToStr = s
Last edited by Teddy; 04-22-04 at