0

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.

Edited by Reverend Jim: Corrected typo in title (Maked -> Masked)

1
Contributor
1
Reply
17
Views
1 Year
Discussion Span
Last Post by VIPER5646
0

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_

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.