Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-30-2006, 02:18 AM   #1
Luddite Lad
Registered User
 
Luddite Lad's Avatar
 
Join Date: Aug 2005
Posts: 177
Thanks: 0
Thanked 0 Times in 0 Posts
Luddite Lad is on a distinguished road
Strange Result

I have a select querey

which contains the expresion
Quote:
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 For the life of me I can't work out what it is that is causing this.

Luddite Lad is offline   Reply With Quote
Old 04-30-2006, 02:24 AM   #2
Luddite Lad
Registered User
 
Luddite Lad's Avatar
 
Join Date: Aug 2005
Posts: 177
Thanks: 0
Thanked 0 Times in 0 Posts
Luddite Lad is on a distinguished road
Sorry should probably mention that [text8] is unbound and has a default value of 1.
Luddite Lad is offline   Reply With Quote
Old 04-30-2006, 07:44 PM   #3
arnodys
Registered User
 
Join Date: Apr 2006
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
arnodys is on a distinguished road
Try to invoke value properties of the method:

Quote:
forms!frm_itemslct!text8.value

arnodys is offline   Reply With Quote
Old 05-01-2006, 02:39 AM   #4
Luddite Lad
Registered User
 
Luddite Lad's Avatar
 
Join Date: Aug 2005
Posts: 177
Thanks: 0
Thanked 0 Times in 0 Posts
Luddite Lad is on a distinguished road
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 rather than the value. However if the default value is change then the query works perfectly

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 by Luddite Lad; 05-01-2006 at 02:42 AM.
Luddite Lad is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
converting numbers to words Roni Sutton Reports 24 12-03-2016 09:18 AM
converting numbers to words mhm181 Modules & VBA 2 09-25-2005 10:31 AM
[SOLVED] Split words in textbox? BackatchaBandit Reports 9 04-29-2003 11:29 PM
Need help on my function (dates) nilses Modules & VBA 2 04-13-2003 01:48 PM
displaying numbers as words jhansen Reports 2 07-25-2001 06:34 AM




All times are GMT -8. The time now is 10:43 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World