Text field wrong value

[xcheshirecat]

I have a form of multiples items, but for now only 1 line


I have a field "Largeur"
and when I put a function using it in another field, it is the wrong value:

[Largeur] gives 3,0625
=[Largeur] gives 10318

so if I use a function, it uses the 10318 instead of the valid value

What is happening ?

[rpeare]

I am guessing this is on a bound form and the field is either in the form header or form footer. If that's the case you will get inconsistent results if you are using =[largeur]. It will likely give you either the first, or last value of largeur in your list of items. The easiest way around this that I can think of is to limit your data entry field to individual records so you are only handling one record at a time. If that's not an option you may have to result to code to update the value in the form header/footer to coincide with the 'current' record.

[xcheshirecat]

I am guessing this is on a bound form and the field is either in the form header or form footer. If that's the case you will get inconsistent results if you are using =[largeur]. It will likely give you either the first, or last value of largeur in your list of items. The easiest way around this that I can think of is to limit your data entry field to individual records so you are only handling one record at a time. If that's not an option you may have to result to code to update the value in the form header/footer to coincide with the 'current' record.

It is on the same level

[rpeare]

is the form MarieLouisesListe a subform of Marie-Louise?
if it's a subform are you using navigation panes, or are you using your own custom built subform?

if it's a navigation pane I suspect that may be something to look at (I don't use navigation panes and someone may be able to answer that better than I could).

I don't know french very well, what does 'Text Brut' mean (raw text?), if you are formatting this field as a text but the value in largeur is a number that could potentially be causing some problems (or vice versa).

[xcheshirecat]

is the form MarieLouisesListe a subform of Marie-Louise?
if it's a subform are you using navigation panes, or are you using your own custom built subform?

if it's a navigation pane I suspect that may be something to look at (I don't use navigation panes and someone may be able to answer that better than I could).

I don't know french very well, what does 'Text Brut' mean (raw text?), if you are formatting this field as a text but the value in largeur is a number that could potentially be causing some problems (or vice versa).

no, it's my list form. When I double-click, it opens the detail form.
text brut is raw text yes. How do I change it to number ? In format I put general number but there's still the case "text format" that is in raw text

[rpeare]

the drop down list of the Format du Texte should give you an option to display the value as a number (long integer perhaps? or double?)

I still think you are using some navigation pane functions because there is a dashed outline around the field in question. As I said I do not use navigation pane options so I am not sure what this denotes or what kind of function it serves. You can try deleting the control you currently have, putting a new control (text box in) and putting the formula back in on that new field (make sure it's not in the dashed outline) and see if you get a better result.

[xcheshirecat]

I don't know what are the navigations panes... If I'm using this, it's not by choice. I created a new form based on the table

What I find weird is that if I write "=[Largeur]" it's the wrong result, but "Largeur" is ok... I don't even know what that number can be. I have only 1 record in this table

The dashed outline seems to appear when I use the automatic disposition (a yellow line appears and the field copy the style)

[rpeare]

if you want to supply an example of your database I can take a look, I'm really just shooting in the dark here. If you want to supply a sample db, just remove any private information from it, compact/repair then zip it up and use the GO ADVANCED button to attach a file to your next post.

[xcheshirecat]

if you want to supply an example of your database I can take a look, I'm really just shooting in the dark here. If you want to supply a sample db, just remove any private information from it, compact/repair then zip it up and use the GO ADVANCED button to attach a file to your next post.

I'm still in coding, so there's no personnal info yet. The form is MarieLouiseList

I hope you won't have problems with the languages, I had some problems with that before (numbers format and stuff)

encadrements petit.zip

[rpeare]

I don't know how you get to the form MarieLouisesListe, I could not find a double click event that you mentioned on any of the controls.

However, I opened the form MarieLouisesListe manually, in the field that currently says =[Width]

I typed in =[largeur] and it duplicated what was in your field [Largeur]

It looks like you deleted the control I mentioned and put in a new control which seems to be functioning the way you want when you change the control source.

[Missinglinq]

However, I opened the form MarieLouisesListe manually, in the field that currently says =[Width]

I typed in =[largeur] and it duplicated what was in your field [Largeur]

I did the same thing, with the same results.

Linq ;0)>

[xcheshirecat]

Thanks guys you made me realise what was the problem.

You saw =[width], but on my side it is [Largeur]

I used the same word as the property. Since you were in english, you don't have the name conflict

[Missinglinq]

Then why does the Bound Control read Largeur, instead of width?

[xcheshirecat]

Because it's bound, it knows it is not a property ?

Anyway, I change my field to LargeurML, so now it works