Selecting Certain Letters From a Table In Access

Hi!
I am using access and my table has a set of data that is in the format 12-34-56 and I have a form which looks this information up. I was wondering if it were possible to have one field on a form that will display the first two numbers (12) and then in a second field display the rest of the numbers but remove the hyphen, all while keeping the data the same on the table. So the back end remains 12-34-56 but the first field displays 12 and the second field displays 3456

any ideas?!

just use left$ and mid$ respectively.

May be this helps...

VB Code:

TheData = "12-34-56"
TheData = Replace(TheData, "-", "", 1, , vbTextCompare)
Text1.Text = Mid$(TheData, 1, 2) ' 12
Text2.Text = Mid$(TheData, 3)      ' 3456

Word of caution.. if you're not using Access 2000 and above the Replace function will not be available to you.

This was my solution, in the control source...

Code:

---

=Replace(Right$(sfrmOHMAll.Form!ATA,Len(sfrmOHMAll.Form!ATA)-3),'-','')

---

thanks all!