Author: kamcginnis@gmail.com
Posted: 2014-04-12 15:17:17 Link
revise my response below. I had a function on the INIT of that text box
that sets the format and inputmask
toobject.Format = "KRZ"
toobject.InputMask = "###-##-####"
Hope this helps:
I am using VFP9 SP2
I have a text box on a form I named txtcSSN
It has a control source: vnmpt.cssn which is a view for a table with the
field named cSSB C(9)
The input mask is 999-99-9999 (same as yours)
The width is 90
Mine works the way you want. Not sure why yours does not.
On 4/12/2014 8:56 AM, Vincent Teachout wrote:
> Jeff Johnson wrote:
>> Greetings: I have a text box who's control source is a social
>> security number stored as a number. Obviously I have done this for
>> years. Yesterday it was brought to my attention that the leading
>> zero messed up the formatting:
>>
>> 012566666 produces 125-66-666 instead of 012-56-6666. I am using an
>> input mask of 999-99-9999.
>>
>> What do I need to do to fix this.
>
> If you're not going to do math with it, it shouldn't be stored as a
> number. Change the field to a char(9), convert the numbers to char
> strings (tranform(), str(), whatever you want), input with format of
> @R and input mask of 999-99-9999.
>
> If you're really, really sure that the mangled numbers are always
> missing one or more zeros, then once you're changed the field to char,
> you can replace all ssn with padl(alltrim(ssn)),9,'0')
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/53499F4D.3090406@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
I'll try it, thanks!
On 4/12/2014 1:17 PM, kamcginnis@gmail.com wrote:
> revise my response below. I had a function on the INIT of that text
> box that sets the format and inputmask
>
> toobject.Format = "KRZ"
> toobject.InputMask = "###-##-####"
>
> Hope this helps:
> I am using VFP9 SP2
>
> I have a text box on a form I named txtcSSN
> It has a control source: vnmpt.cssn which is a view for a table with the
> field named cSSB C(9)
> The input mask is 999-99-9999 (same as yours)
> The width is 90
>
> Mine works the way you want. Not sure why yours does not.
>
>
> On 4/12/2014 8:56 AM, Vincent Teachout wrote:
>> Jeff Johnson wrote:
>>> Greetings: I have a text box who's control source is a social
>>> security number stored as a number. Obviously I have done this for
>>> years. Yesterday it was brought to my attention that the leading
>>> zero messed up the formatting:
>>>
>>> 012566666 produces 125-66-666 instead of 012-56-6666. I am using an
>>> input mask of 999-99-9999.
>>>
>>> What do I need to do to fix this.
>>
>> If you're not going to do math with it, it shouldn't be stored as a
>> number. Change the field to a char(9), convert the numbers to char
>> strings (tranform(), str(), whatever you want), input with format of
>> @R and input mask of 999-99-9999.
>>
>> If you're really, really sure that the mangled numbers are always
>> missing one or more zeros, then once you're changed the field to char,
>> you can replace all ssn with padl(alltrim(ssn)),9,'0')
>>
>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5349B6CF.209@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Jeff Johnson
Posted: 2014-04-14 08:23:32 Link
.format - "KRL" does the trick. The reason I don't change to a string
is because this application is many years old and deployed in numerous
locations throughout the US and Canada. I avoid file format changes if
at all possible. In newer applications I am storing phone numbers and
social security numbers in text.
Thanks all for your help.
On 4/12/2014 1:17 PM, kamcginnis@gmail.com wrote:
> revise my response below. I had a function on the INIT of that text
> box that sets the format and inputmask
>
> toobject.Format = "KRZ"
> toobject.InputMask = "###-##-####"
>
> Hope this helps:
> I am using VFP9 SP2
>
> I have a text box on a form I named txtcSSN
> It has a control source: vnmpt.cssn which is a view for a table with the
> field named cSSB C(9)
> The input mask is 999-99-9999 (same as yours)
> The width is 90
>
> Mine works the way you want. Not sure why yours does not.
>
>
> On 4/12/2014 8:56 AM, Vincent Teachout wrote:
>> Jeff Johnson wrote:
>>> Greetings: I have a text box who's control source is a social
>>> security number stored as a number. Obviously I have done this for
>>> years. Yesterday it was brought to my attention that the leading
>>> zero messed up the formatting:
>>>
>>> 012566666 produces 125-66-666 instead of 012-56-6666. I am using an
>>> input mask of 999-99-9999.
>>>
>>> What do I need to do to fix this.
>>
>> If you're not going to do math with it, it shouldn't be stored as a
>> number. Change the field to a char(9), convert the numbers to char
>> strings (tranform(), str(), whatever you want), input with format of
>> @R and input mask of 999-99-9999.
>>
>> If you're really, really sure that the mangled numbers are always
>> missing one or more zeros, then once you're changed the field to char,
>> you can replace all ssn with padl(alltrim(ssn)),9,'0')
>>
>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/534BE154.9090107@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Jeff Johnson
Posted: 2014-04-14 08:30:50 Link
.format - "KRLZ" is even better. Shows a blank of no social security
number.
On 4/14/2014 6:23 AM, Jeff Johnson wrote:
> .format - "KRL" does the trick. The reason I don't change to a string
> is because this application is many years old and deployed in numerous
> locations throughout the US and Canada. I avoid file format changes
> if at all possible. In newer applications I am storing phone numbers
> and social security numbers in text.
>
> Thanks all for your help.
>
>
> On 4/12/2014 1:17 PM, kamcginnis@gmail.com wrote:
>> revise my response below. I had a function on the INIT of that text
>> box that sets the format and inputmask
>>
>> toobject.Format = "KRZ"
>> toobject.InputMask = "###-##-####"
>>
>> Hope this helps:
>> I am using VFP9 SP2
>>
>> I have a text box on a form I named txtcSSN
>> It has a control source: vnmpt.cssn which is a view for a table with the
>> field named cSSB C(9)
>> The input mask is 999-99-9999 (same as yours)
>> The width is 90
>>
>> Mine works the way you want. Not sure why yours does not.
>>
>>
>> On 4/12/2014 8:56 AM, Vincent Teachout wrote:
>>> Jeff Johnson wrote:
>>>> Greetings: I have a text box who's control source is a social
>>>> security number stored as a number. Obviously I have done this for
>>>> years. Yesterday it was brought to my attention that the leading
>>>> zero messed up the formatting:
>>>>
>>>> 012566666 produces 125-66-666 instead of 012-56-6666. I am using an
>>>> input mask of 999-99-9999.
>>>>
>>>> What do I need to do to fix this.
>>>
>>> If you're not going to do math with it, it shouldn't be stored as a
>>> number. Change the field to a char(9), convert the numbers to char
>>> strings (tranform(), str(), whatever you want), input with format of
>>> @R and input mask of 999-99-9999.
>>>
>>> If you're really, really sure that the mangled numbers are always
>>> missing one or more zeros, then once you're changed the field to char,
>>> you can replace all ssn with padl(alltrim(ssn)),9,'0')
>>>
>>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/534BE30A.3090400@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2014-04-15 09:46:19 Link
On 2014-04-12 16:17, kamcginnis@gmail.com wrote:
> revise my response below. I had a function on the INIT of that text
> box that sets the format and inputmask
>
> toobject.Format = "KRZ"
> toobject.InputMask = "###-##-####"
>
> Hope this helps:
> I am using VFP9 SP2
>
> I have a text box on a form I named txtcSSN
> It has a control source: vnmpt.cssn which is a view for a table with
> the
> field named cSSB C(9)
> The input mask is 999-99-9999 (same as yours)
> The width is 90
Why is your width 90? Why not 9? Or did you mean that and just had a
typo in the message?
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/eb7a30ffff6c1104970f0cd5da3a2683@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: kamcginnis@gmail.com
Posted: 2014-04-15 14:06:38 Link
90 is correct for the Width property
On 4/15/2014 7:46 AM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
> On 2014-04-12 16:17, kamcginnis@gmail.com wrote:
>> revise my response below. I had a function on the INIT of that text
>> box that sets the format and inputmask
>>
>> toobject.Format = "KRZ"
>> toobject.InputMask = "###-##-####"
>>
>> Hope this helps:
>> I am using VFP9 SP2
>>
>> I have a text box on a form I named txtcSSN
>> It has a control source: vnmpt.cssn which is a view for a table with the
>> field named cSSB C(9)
>> The input mask is 999-99-9999 (same as yours)
>> The width is 90
>
>
>
> Why is your width 90? Why not 9? Or did you mean that and just had a
> typo in the message?
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/534D833E.3000002@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Michael: Fit your social security in a textbox txtssan.width = 9 ;^)
On 4/15/2014 1:20 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
> On 2014-04-15 15:06, kamcginnis@gmail.com wrote:
>> 90 is correct for the Width property
>>
>
>
> Is that because you're encrypting it so hence the wider field needed?
> The light bulb just went on when re-reading this. Of course you
> wouldn't store someone's SSN in plain text!
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/534D937D.6070402@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2014-04-15 15:20:21 Link
On 2014-04-15 15:06, kamcginnis@gmail.com wrote:
> 90 is correct for the Width property
>
Is that because you're encrypting it so hence the wider field needed?
The light bulb just went on when re-reading this. Of course you
wouldn't store someone's SSN in plain text!
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/7fd1dbc85e3b55afca9ba45e06b557e0@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Pixels, Mike, pixels.
Fred
On Tue, Apr 15, 2014 at 1:20 PM, <
mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
> On 2014-04-15 15:06, kamcginnis@gmail.com wrote:
>
>> 90 is correct for the Width property
>>
>>
>
> Is that because you're encrypting it so hence the wider field needed? The
> light bulb just went on when re-reading this. Of course you wouldn't store
> someone's SSN in plain text!
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJCBksrNP-AtEZjDmxo1Su8D=jDn2VG-7S203EE+5=k2Vpw5nQ@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
You are blonde if I remember correctly. ;^) The smallest width for a
textbox is 13 on my computer. The control source is a field of C(9) but
the width of the control is 90 (pixels I think).
On 4/15/2014 1:25 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
> I must be having a blonde moment: 123-45-6789. With the format and
> inputmask, wouldn't 9 suffice?
>
>
> On 2014-04-15 16:15, Jeff Johnson wrote:
>> Michael: Fit your social security in a textbox txtssan.width = 9 ;^)
>>
>> On 4/15/2014 1:20 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
>>> On 2014-04-15 15:06, kamcginnis@gmail.com wrote:
>>>> 90 is correct for the Width property
>>>>
>>>
>>>
>>> Is that because you're encrypting it so hence the wider field
>>> needed? The light bulb just went on when re-reading this. Of
>>> course you wouldn't store someone's SSN in plain text!
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/534D9551.7000209@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.