View Single Post
  #2 (permalink)  
Old June 15th, 2005, 04:29 AM
mjppaba mjppaba is offline
Friend of Wrox
 
Join Date: Jan 2005
Location: Bournemouth, Dorset, United Kingdom.
Posts: 180
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What you could do if you wanted to use an input box rather than a user defined form (UDF) is to set the default value for the input box to " " (space) rather than a zero length string. If the user clicks OK then a space is passed, if Cancel then a zero lenth string is paased.

I would strongly suggest the use of a UDF if you want to recognise the click properties of different buttons.

Cheers

Matt

Reply With Quote