Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1153
  • Last Modified:

Mask for TQRDBText

Hi, can someone help me on this

I use Paradox tables ----> field value: 0123456789

When I use QR --> TQRDBText --> output should be: 0123.456.789

I tried to use the mask property, but still on the printout (or preview) I get 0123456789

What am I doing wrong ?

thx
marioway
0
marioway
Asked:
marioway
1 Solution
 
Ivanov_GCommented:
make this field Calculated and use Format function to do it like this in OnCalcFields event ...
0
 
calinutzCommented:
You probabely use a wrong mask. What type of mask did you place in the mask property? And what exactly does your number  0123.456.789 represent? Is it a phone number or what?
0
 
mariowayAuthor Commented:
Hi, the number is a Belgian VAT number (in the database I put it in a field: alfanum  length 11 )
I Used the mask: '____.___.___' without the quotes.

marioway
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
esoftbgCommented:
It does not work with Decimal separator, but
I did a successful examples using Mask property of the TQRDBText:

0###_0##_0##
0###`0##`0##
0###~0##~0##

I probably will work with many different separators
0
 
esoftbgCommented:
Possible separator:
ยท
Alt + 0183
0
 
mariowayAuthor Commented:
Hello, It still does not work.

marioway
0
 
esoftbgCommented:
download a workink example from:
page:        http://www.geocities.com/esoftbg/
  link:        Q_21156392.zip
0
 
mariowayAuthor Commented:
Hi, thank you very much esoftbg. It works fine this way.

Marioway
0
 
esoftbgCommented:
marioway, you are welcome !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now