Can someone help me Split a variable. I am trying to split it and place the results in the caption part of a label. Whenever I try this though I get a data type mismatch error. The code I am trying to use is; SaveAsForm is a predefined String?
LabelTitle.Caption = Split(SaveAsForm, "frm")