strings in text box control source

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Can I use a string variable in the control source of a textbox.
eg: =DateSerial(Year([str_formdate]),Month([str_Formdate]),1)
Shows the first of the month of str_formdate. str_formdate is defined as
Date

If so, this does not work...what might?
 
The text box displays #name?

Douglas J. Steele said:
What happens when you try it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Jeff said:
Can I use a string variable in the control source of a textbox.
eg: =DateSerial(Year([str_formdate]),Month([str_Formdate]),1)
Shows the first of the month of str_formdate. str_formdate is defined as
Date

If so, this does not work...what might?
Click to expand...
Click to expand...
 
Back
Top