Input Mask for Multiple Feilds in a Text Box

[Hollis]

Hi All,

I am making a details list with names, address, phone numbers all the usual stuff.

For the phone numbers, on the form I have seperate inputs for a mobile and landline. Formatting the input mask for these is easy as the are two seperate objects.

Landline mask: !\09\ 0000\ 0000;;_
Comes out as: 03 1111 1111
Mobile number mask: !\0999\ 000\ 000;;_
Comes out as: 0411 111 111

Now on the form I am putting these two feilds in the same text box so that if you have one and not the other it shows up in line, and if you have both the text box will grow and the second number will be put under neith.

My problem is trying to have the seperate input masks applied to the two seperate feilds. I have no idea how to do this.

This is what I have to show the two numbers:
=[ContactNumber] & " " & [MobileNumber]

And they come out like:
311111111 411111111

Thanks

 

[Hollis]

I've tried:
Format([ContactNumber],'!\09\ 0000\ 0000;;_')

But it comes up with:
09 0000 0000

 

[boblarson]

two fields in the same text box for entry?

1. Not wise

2. Not going to happen.

You can DISPLAY the two together but you should have two separate text boxes for ENTRY.

 

[Hollis]

Sorry, I've made an error.

It's ment to read:

Now on the report I am putting these two feilds in the same text box so that if you have one and not the other it shows up in line, and if you have both the text box will grow and the second number will be put underneath.