Hide First 6 Digits in Textbox (1 Viewer)

[whojstall11]

I am trying to hide the first 6 digits in a textbox and only show the last for digits in a text box.

So far I a putting my code in the Format Format section in Property Sheet of a form. Its not seeming to work. What am I doing wrong?

 Left([Card Number],Len([Card Number])-6)

 

[pbaldy]

I'd simply use a formula in a textbox, like:

=Right([Card Number], 4)

Or the Mid() function if it isn't always 4 digits.

 

[whojstall11]

Ok thank you that worked

 

[whojstall11]

Well I take it back is there a way I can still store all of the numbers in my table but only display the last for in form?

 

[pr2-eugin]

Make the Control unbound..

 

[pbaldy]

Well I take it back is there a way I can still store all of the numbers in my table but only display the last for in form?

That would simply affect the display. You'd want to use a different form or textbox to enter the data.

 

[whojstall11]

It worked I end up making another column on my table then in my form I had it take the last four from my new column. (that the short explantation) Thanks.

 

[pbaldy]

Glad you got it sorted out.