https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/77208.aspxThu, 05 Apr 2012 18:16:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:77208Anson Hidajat0https://www.infopathdev.com:443/forums/thread/77208.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=77208<p>If you want to generate a random number, you&#39;ll have to write custom code.&nbsp; Alternatively, qRules has a GenerateNumber function which you can use to generate a random ID without having to write your own code.</p><p>More on qRules: <a href="http://www.qdabra.com/en/products/qRules_new.aspx">http://www.qdabra.com/en/products/qRules_new.aspx</a></p>https://www.infopathdev.com:443/forums/thread/77192.aspxThu, 05 Apr 2012 14:45:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:77192glennyboi0https://www.infopathdev.com:443/forums/thread/77192.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=77192<span style="FONT-FAMILY:&#39;Arial&#39;,&#39;sans-serif&#39;;FONT-SIZE:10pt;">is it possible to randomise text displayed in an expression box? </span><span style="FONT-FAMILY:&#39;Arial&#39;,&#39;sans-serif&#39;;FONT-SIZE:10pt;">I have set up a box on my form for announcements that will automatically retrieve the content from an access data base table and display it in the announcements box. The Access table has an ID as the primary key. Is there any way to get the text to randomise on opening the sheet and the box formula randomly retrieving a line ID, thus displaying different text each time?</span><span style="FONT-FAMILY:&#39;Arial&#39;,&#39;sans-serif&#39;;FONT-SIZE:10pt;">hope that makes since</span> <p><span style="FONT-FAMILY:&#39;Arial&#39;,&#39;sans-serif&#39;;FONT-SIZE:10pt;">thanks</span></p>