Solved

Mask for TQRDBText

Posted on 2004-10-05
9
1,115 Views
Last Modified: 2012-05-05
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
Comment
Question by:marioway
9 Comments
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 12226677
make this field Calculated and use Format function to do it like this in OnCalcFields event ...
0
 
LVL 11

Expert Comment

by:calinutz
ID: 12226682
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
 

Author Comment

by:marioway
ID: 12227652
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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 12

Expert Comment

by:esoftbg
ID: 12229146
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
 
LVL 12

Expert Comment

by:esoftbg
ID: 12229294
Possible separator:
·
Alt + 0183
0
 

Author Comment

by:marioway
ID: 12235853
Hello, It still does not work.

marioway
0
 
LVL 12

Accepted Solution

by:
esoftbg earned 50 total points
ID: 12236854
download a workink example from:
page:        http://www.geocities.com/esoftbg/
  link:        Q_21156392.zip
0
 

Author Comment

by:marioway
ID: 12237262
Hi, thank you very much esoftbg. It works fine this way.

Marioway
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 12237857
marioway, you are welcome !
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now