Strange Result (1 Viewer)

Luddite Lad

Registered User.
Local time
Today, 15:46
Joined
Aug 23, 2005
Messages
177
I have a select querey

which contains the expresion
forms!frm_itemslct!text8
It should just pick up the value contained within [Text8] which is a number, and it was doing that earlier this evening. I've since changed something and instead of a number it is now showing a small square :confused: For the life of me I can't work out what it is that is causing this.
 

Luddite Lad

Registered User.
Local time
Today, 15:46
Joined
Aug 23, 2005
Messages
177
Sorry should probably mention that [text8] is unbound and has a default value of 1.
 

arnodys

Registered User.
Local time
Today, 15:46
Joined
Apr 24, 2006
Messages
20
Try to invoke value properties of the method:

forms!frm_itemslct!text8.value
 

Luddite Lad

Registered User.
Local time
Today, 15:46
Joined
Aug 23, 2005
Messages
177
I Don't understand why but the problem is with the default value.

If the default value of 1 is left in [text8] then the query returns a small square :eek: rather than the value. However if the default value is change then the query works perfectly :confused:

Solution remove the default value for [text8]

.......Sorry I dicoverd this whilst trying our arnodys suggestion; his suggestion also returned the small square if the default value was not changed.
 
Last edited:

Users who are viewing this thread

Top Bottom