Access 2003 writing html into memo field from text fields
Posted on 2007-10-13
I have an Acces 2003 database that I am using to organize a web store. The database contains various fields needed to identify a product that is uploaded to the store using a simple text querry. I have a form that displays the details, price, availablity, pictures, etc for the product, and a large memo field where I write the html to be uploaded to the store.
I have a list of up to 15 features for each item, and my goal is to list them individually as text, then grab them, insert them between code to create a box that displays the features in a box that alternates between background colors. (Seems as it would be efficient rather than coding that for 1500 products individually)
I have two problems,
1) assuming i can write a program to count the number of features, and then apply the correct sequence of text in front of and behind the 'feature', can that new text be written into an access memo field?
2) can the routine be written in access to accomplish this? The first and last line of the html would differ, the middle lines would alternate the background color, and it is best if the html is on separate lines as in the template below
feature 1 (first line)
1 <table width="100%" border="0">
3 <td bgcolor="#cff8f9"> FEATURE 1 </td>
feature 2 (repeats and alternates color)
2 <td> FEATURE 2 </td>
feature 3 (last feature)
2 <td>FEATURE 3</td>
My access ability is intermediate (on the low end), same with html.
Any input would be appreciated.