Input Button Command Question

R

rob nobel

Hi all,
Is there a way to have an input button show a default value formatted in
date format. That is as d/m/yyyy. (I can get it to show the date but
insists on showing it in number format only)
 
B

BrianB

Don't know what you mean by "Input Button".
Could try something like :-
mystring = Format(Date, "d/m/yyyy")
CommandButton1.Caption=mystring
 
R

rob nobel

Thanks Brian. Sorry about being unclear. The function is for an InputBox
NOT Input Button. Your solution seems to do the trick though by just using
Format(Date, "d/m/yyyy") as the default.
Rob
 
Top