0
I have created a report in Microsoft Access which contains a text box. The text box has a simple expression in the control source to generate a random string of digits in a specific format. I need to replicate the exact string of digits in a second text box. That is the same random string of digits must exist in two text boxes. Setting the second text box to the first text box's Text
property only resulted in an error and directly inserting in control source =[RandomText1]
resulted in a new random string of digits being developed in text box two with the algorithm in text box one. What can I do to create a single set of random digits and show it in two text boxes in Microsoft access? I am using Access 2007-2010 (That's just what it says so I think its actually 2010).