Results 1 to 4 of 4
  1. #1
    gph004 is offline Novice
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Posts
    2

    Question Question regarding =Now()







    I've a little question with my Form , I inserted The function =Now() into the Default Value Field , and after i entered the data , upon pressing the "Next" Button , the error shown above is shown .

    Thanks in Advance

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    I don't know why this might be part of your problem, but shouldn't

    the text box be bound to a table or query? In other words, won't the registration date ultimately be stored as part of a record?

  3. #3
    gph004 is offline Novice
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Posts
    2
    Quote Originally Posted by hertfordkc View Post
    the text box be bound to a table or query? In other words, won't the registration date ultimately be stored as part of a record?
    So , Do i Just Type in the FieldName on the Control Source ?
    Sorry , Total Noob

  4. #4
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Yes, although you may have to have brackets around the

    [fieldname] to help VB sort out that it isn't another control or variable name.

    Quote Originally Posted by gph004 View Post
    So , Do i Just Type in the FieldName on the Control Source ?
    Sorry , Total Noob
    If it still gives you a problem, I'll get on my Access box and sort it out.

Please reply to this thread with any new information or opinions.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums