adding tekst
in [Reports]
|
Prev: D Look-up? Auto fill Collumns on a table/Form based on another col
Next: To have selected the year on combo box
From: Jean-Paul on 28 Nov 2009 09:17 I have this entryfield on my report. I use a recordfield to display it's data ABO_Stage When I change it into ="Bedrijf: " & [ABO_Stage] I get a # error What is wrong with the syntax? Thanks
From: Marshall Barton on 28 Nov 2009 09:34 Jean-Paul wrote: >I have this entryfield on my report. > >I use a recordfield to display it's data > >ABO_Stage > >When I change it into > >="Bedrijf: " & [ABO_Stage] > >I get a # error > >What is wrong with the syntax? Nothing is wrong with the syntax. The problem is that when you changed it from a bound text box to an expression (by using =), you forgot to change the name of the text box to something other than ABO_Stage. The way you have it, the expression refers to the text box and the expression goes around in circles trying to evaluate itself. -- Marsh MVP [MS Access]
From: Jean-Paul on 28 Nov 2009 09:49
Perfect... problem solved Thanks Marshall Barton wrote: > Jean-Paul wrote: > >> I have this entryfield on my report. >> >> I use a recordfield to display it's data >> >> ABO_Stage >> >> When I change it into >> >> ="Bedrijf: " & [ABO_Stage] >> >> I get a # error >> >> What is wrong with the syntax? > > > Nothing is wrong with the syntax. The problem is that when > you changed it from a bound text box to an expression (by > using =), you forgot to change the name of the text box to > something other than ABO_Stage. The way you have it, the > expression refers to the text box and the expression goes > around in circles trying to evaluate itself. > |