Three fields shown together.

[Aeon.Divine]

This must be in the big BASIC KNOWLEDGE BOOK OF ACCESS. But i honestly don't know how it's done, so:

Lets say we have three fields, "description", "color" and "material", this fields are taken from a query by a report. And the report has to show all three of them together in the same texbox. Not only has the report to show them together, but to link them in a sentence like this:

[DESCRIPTION] + "In color" + [COLOR] + "Constructed with" + [MATERIAL]

So then, what should i write in the control of the textbox that should display all this ? Or should this be done in VB ?

 

[pbaldy]

=[DESCRIPTION] & "In color" & [COLOR] & "Constructed with" & [MATERIAL]

presumably you'll want to add some spaces in there.

 

[Aeon.Divine]

I tried that way, but access tells me thats a non valid control. It also states something about a circular reference. Whats that ?

 

[georgedwilkinson]

In some DBMSs "Description" is a reserved word. That could be your problem and if so, you'll need to qualify it.

Are the field names spelled correctly? Are you referring to column names or control names?

 

[pbaldy]

Also, make sure you don't have a control with any of those names (which is what the wizard will create). Access can get confused when a field and control have the same name.

 

[Aeon.Divine]

It seems like the "Description" field is definitively the problem, its a field refered in a query. But the textbox can show without any problem the description field alone, it just cannot show the description field along with colour or material. Colour an material field show themselves if i chain them in the textbox as you show me, but no field can showitself along with description, even if i write it with the whole location to prevent errors. And yes, the fields are definitively spelled correctly.

 

[boblarson]

Check this out for reserved words:
http://support.microsoft.com/kb/q286335/

and Description is one of them.

 

[pbaldy]

Did you read post 5?

 

[Aeon.Divine]

Nah, i thing we posted almost at the same time, i'm checking now. It seems like there are no controls called description inside the report. Refering to the field stating the origin should fix the "DMBS" deal, right ? Cause it doesnt...

 

[pbaldy]

I'll bet a frosty cold one that there is a control named description (we Nevadans like gambling). Won't be the first bet I've lost, but I win more than I lose.

Can you post a sample db?

 

[Aeon.Divine]

I'll post it tomorrow when i return to work. You'll have you bet, and if you get to win, then i'll win as well.

 

[Aeon.Divine]

Mi database is way too complex to simplify it, so, heres just the form, i've erased the query origin control, the "Descripcion" field was obviously included there. Im Argentinian, so my file is in spanish, hope you don't mind, has practicaly no diference at all. Good luck finding the control.

 

[pbaldy]

Is this a winner?

 

[Aeon.Divine]

!!! Now i get what you were saying! I knew that was there, but i mixed up my definition of control and source or origin, so i was searching for a second control, as if the error would be caused by multiple controls. Now's fixed, and running damn well, thanks pbaldy. im in your debt.

Let there be rep!

 

[pbaldy]

Keep the rep, send Argentinian wine!

Glad we got it sorted out.