Hi all
I have a table with a Masked column.
How can I INSERT or UPDATE data into the masked column at run Time with out Loading the column into a textbox.
The column is as Folows

ID      Process
1    StartY CompleatY
2    Start_ Compleat_

Thanks in advance.

I Have Solved by using the Left and Right Functions to separate the left and right of the value.
Here is a code Snipid how I did for future Users.

  RightSide = Right(wbook.Mask.Trim, 36)
  LeftSide = Left(wbook.Mask.Trim, 27)
  UpdateValue = LeftSide & Value & RightSide

RightSide would equal Start
LeftSide equals Compleate
UpdateValue equals Starty Compleate_