Member Avatar for VIPER5646

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 because: Corrected typo in title (Maked -> Masked)
  • 1 Contributor
  • 1 Reply
  • 194 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by VIPER5646
Member Avatar for VIPER5646

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_

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.