Results 1 to 3 of 3
  1. #1
    lmjje is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    12

    Text appearing every time form is opened.

    For anyone that can help...I have text in a field that is automatically appearing in several fields on an interview form some examples are:

    1. What is your current role?


    2. What are you seeking in your next position?
    3. Is there anything else you would like to see in your next role?

    The problem I am having is that it also appears every time the form is opened regardless if there is other text already in the field (it adds the string above to whatever is in the field already).

    How can I get it to only appear only if no other text is present in the field?

    Any help would be greatly appreciated.

  2. #2
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Well.... without knowing any element names or anything....

    Are the
    1. What is your current role?
    2. What are you seeking in your next position?
    3. Is there anything else you would like to see in your next role?
    labels?
    The answer fields, are they text-boxes?

    You could do an onload or on current event...

    Tell you what, give me the names of the questions, and answer fields and the form and I might be able to piece together a module for ya. I have a slow day today.



  3. #3
    lmjje is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    12
    No the fields are:

    CurrentSituationQuestion1
    CurrentSituationQuestion2
    ...and so forth.

    The label displays are:

    Current Situation (Question 1)
    Current Situation (Question 2)
    ...and so forth.

    The text listed in my opening question is autofill text to help guide an interviewer or recruiter through the initial screening process. The text can be overridden if it does not flow with the way the interview is going...it is only there as a guide. The problem is that it is appearing everytime the form is opened...it just tacks the question to the end of whatever is in the field. I only want it to appear if there is no other text in the field. I am pretty sure that I will have to do it in VBA, but I am at a loss for how to structure the code.

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

Similar Threads

  1. Replies: 3
    Last Post: 06-06-2012, 12:45 PM
  2. Replies: 4
    Last Post: 07-27-2011, 09:25 AM
  3. Replies: 1
    Last Post: 07-27-2011, 09:19 AM
  4. Replies: 1
    Last Post: 01-23-2011, 09:21 AM
  5. Replies: 2
    Last Post: 08-12-2010, 11:21 PM

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