If statement to choose formating for unbound text box

[Erin]

hi there,

I am trying to create a report based on an input for full of Reference
Citations for research reports.

We have 5 different media types, Archaeological Reports, Article, Book, map
and Unpublished document.

So for example record 1 may be a reference citation for an article, record 2
may be a citation for a map. There are 51 one of these different reference
citations.

I need to create a report that will show all 51 of these citations with the
proper formating for that cititation.

my original idea was to have on a button that opened the report with an if
statement in VB saying if the document type was a map then the unbound box
(which is a string of title, year, repository etc) would be formatted this
way and contain specific fields, else if the document type was this the
unbound box would be formated this way and contain the specific fields.

That route was not working for me. Also i should add the document type is a
seperate lookup table.

I am using access 2003. Any help would be greatly appreciated. Not sure
where to start......

 

[Piet Linden]

hi there,

I am trying to create a report based on an input for full of Reference
Citations for research reports.

We have 5 different media types, Archaeological Reports, Article, Book, map
and Unpublished document.

So for example record 1 may be a reference citation for an article, record 2
may be a citation for a map. There are 51 one of these different reference
citations.

I need to create a report that will show all 51 of these citations with the
proper formating for that cititation.

my original idea was to have on a button that opened the report with an if
statement in VB saying if the document type was a map then the unbound box
(which is a string of title, year, repository etc) would be formatted this
way and contain specific fields, else if the document type was this the
unbound box would be formated this way and contain the specific fields.

Ouch...
Try this yet?:
http://www.gradware.com/product/search/?product_search_text=reference+manager&x=0&y=0

I thought you used to be able to download a demo copy... maybe not
anymore...

 

[Piet Linden]

hi there,

I am trying to create a report based on an input for full of Reference
Citations for research reports.

We have 5 different media types, Archaeological Reports, Article, Book, map
and Unpublished document.

So for example record 1 may be a reference citation for an article, record 2
may be a citation for a map. There are 51 one of these different reference
citations.

I need to create a report that will show all 51 of these citations with the
proper formating for that cititation.

my original idea was to have on a button that opened the report with an if
statement in VB saying if the document type was a map then the unbound box
(which is a string of title, year, repository etc) would be formatted this
way and contain specific fields, else if the document type was this the
unbound box would be formated this way and contain the specific fields.

Ouch...
Try this yet?:
http://www.gradware.com/product/search/?product_search_text=reference+manager&x=0&y=0

I thought you used to be able to download a demo copy... maybe not
anymore...