Search results

hello, I need to use the numeric value in a unbound textbox in the WHERE clause of query .... how could I set a UNBOUND TEXTBOX as NUMERIC ??? :confused: thanks

thanks .... but could you show me by a simple example ? how could i do the validation after the trimming , and RETURN to the textbox if the data is invalid ??? sorry for asking this kind of stupid question , but i'm quite a dummy :p

thanks a lot, however, AfterUpdate comes AFTER validation e.g. a textbox named "txtbox" has a validation rule set as Len([txtbox]) > 3 well, if I then place the TrimText routine as suggested by Mile-O-Phile, in the AfterUpdate event as "=TrimText([txtbox]" Here is the problem : I entered...

thanks a lot, however, AfterUpdate comes AFTER validation e.g. a textbox named "txtbox" has a validation rule set as Len([txtbox]) > 3 well, if I then place a TrimText routine as suggested by Mile-O-Phile : Public Function TrimText(txt As TextBox) As Boolean On Error Goto Err_TrimText...

Hello, I would like to transform the data entered in a textbox by Trim(UCase( )), such that I can make sure no space and lower case letters in text field. Where (which event) should I place that macro such that the transformation takes place BEFORE data validation and integrity check ? i.e...

Hello, Is it possible to have some "general" macro such that I can format text boxes using "self-reference" like "[Me]" ?? e.g. SetValue [Me]!Value to Trim([Me]!Value) It seems ridicious to refer to different text boxes each time Thanks a lot