Results 1 to 4 of 4
  1. #1
    walt44 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    3

    Control Source Data Question

    High everyone!
    The problem I am running into is I have an Access Database that has been storing a number of items and has been doing great. But I just recently created

    and added a new Report with a text Box. In this field or text box, I am trying too get a value to be displayed that when data is entered it will spit

    out the entered data and display it with and * in the front and back. For example... I run the report, it asks me to input the data, I type in 1234, I

    then want this data to be returned to me in a separate text box in that same report with with the value *1234*. I want it to do this every time I run

    this report, but I am not sure what the correct string is to place into the Data Control Source Field under that Text Boxes Property Sheet.

    This is what I have entered in it so far with no luck = "*" & [Tag] & "*"



    If anyone can help me with this it would be greatly appreciated.

    Thanks

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

    Not much infohere so let me guess and you tell me whats wrong.

    Quote Originally Posted by walt44 View Post
    High everyone!
    The problem I am running into is I have an Access Database that has been storing a number of items and has been doing great. But I just recently created

    and added a new Report with a text Box. In this field or text box, I am trying too get a value to be displayed that when data is entered it will spit

    out the entered data and display it with and * in the front and back. For example... I run the report, it asks me to input the data, I type in 1234, I

    then want this data to be returned to me in a separate text box in that same report with with the value *1234*. I want it to do this every time I run

    this report, but I am not sure what the correct string is to place into the Data Control Source Field under that Text Boxes Property Sheet.

    This is what I have entered in it so far with no luck = "*" & [Tag] & "*"

    If anyone can help me with this it would be greatly appreciated.

    Thanks
    You have an unbound text box from which you want to transfer an entry into another box/field which is part of the report. If this is the case, you need to add afterupdate event in the unbound text box which transfers the entry to the report. The "*" & [Tag] & "*" just doesn't give enough information about the controls to allow even an educated guess as to what you need. If you can remove confidential info, compact, and zip the database, I'll take a look if you are using Access 2007 or earlier.

  3. #3
    walt44 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    3

    Sure thing

    Sure thing I can remove any confidential data and send you the DB. It is a pretty complex database but I believe I can slim it down enough so it won't be as cumber son when you get into it.

  4. #4
    walt44 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    3

    Figured it out

    I was able to figure it out, the problem I was running into was pretty simple I had incorrectly labeled the TextBoxes. The Text box that was receiving the typed in data for example is called Text17. On the "unbound Text box" where I wanted the value to be displayed was called Text2. So in the Control Source for Text2 I used this command to bring the value from Text17 box to the Text2 box and change its data layout.

    ="*" & [Text17] & "*"

    After I implemented this, and ran the report it kicked back the value I was looking for.

    Data Entered on running report = 1234
    Valued Returned in Text box 2 = *1234*

    Thanks for all the help and work put into this, its much appreciated.

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

Similar Threads

  1. Replies: 5
    Last Post: 10-13-2011, 03:36 PM
  2. Conditional Control Source
    By tylerg11 in forum Programming
    Replies: 4
    Last Post: 09-26-2011, 07:47 AM
  3. Dlookup as Control Source
    By alsoto in forum Forms
    Replies: 1
    Last Post: 08-28-2011, 07:05 PM
  4. control source
    By nashr1928 in forum Forms
    Replies: 5
    Last Post: 03-12-2011, 09:31 PM
  5. Control Source
    By sarah54 in forum Access
    Replies: 1
    Last Post: 03-07-2011, 09:00 PM

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