Recent content by cmartin19

Thanks that got it.

not really, I want a text string to appear if there is a Y in the field. str("additional requirements") does that clear it up? Sorry I was so vague before.

How should this go: Code: IF {table1.field1}="Y" Then "Text" /Code I want the text to display if the field value is "Y" . I know that this should be a Y/N field, but nonetheless the field is still displaying "Y" I just can't see mto get over the hump on this one. Thanks

I can't get scroll bars for a linked word document to show. The document is 4 pages, and I need to be able to run through all 4 without reloading the form over and over. Any help?

I need to join 2 fields into one. I have a FirstName and a LastName field that I need to add to a FullName Field. Is there a way to do this? I was looking at union queries, but is that the right route to take?

If the images are referred to on the table/query you need to make sure that they are referred to in the report or underlying query. Hope that helps.

I need to have a toggle button change color when it changes state from Green(true) to Red(false)

That works for my purposes thanks to all who helped

more info I am trying to get the output to look like 030214-00001 once I have finished. A calculation doesn't seem to be right. If I try to use one field to show 2 types of data from different fields I get a data mismatch error. Please correct me if I'm wrong, I am very new to this. To re...

I need to set up an identifier field that contians the date and unit identifier from another field. In yymmdd-[Unit_ID] format, I get the date to output correctly, but I need to get the Unit_ID data from another field. Any suggestions appreciated.