can I have a fill-in field in a report ?

[Roger]

I have a report that gives a value in the report footer. The value needs to
be in euros, numbers and words. I can calculate the numbers okay, but as far
as I am aware there is no function to convert numbers into words in Dutch.
Thus, I need to have a fill-in field for the value in words, with the prompt
including the value in numbers !

Is this possible ????

I will be eternally grateful for any answers ... Rod

 

[Allen Browne]

See:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

Since you clearly understand English as well, it should be easy enough to
change the words in that funtion into Dutch, e.g. substitute the correct
word instead of "hundred".

 

[Ro477]

Thanks for the link, I have had a look at it and copied it into the module
section of the database. But this is a level above what I have done in the
past (so far I have been strictly a macro person !!!). Now I have it in the
database how do I link it to the text box concerned to convert the number to
words ?

 

[Allen Browne]

The function was named English() and it accepted a vaue of type Currency. So
if your field is named Amount, you would put this in the Control Source of
the text box on your report:
=English([Amount])

Actually that could error if the field was null, so it would be better to
use
=English(Nz([Amount],0)

 

[Ro477]

Thanks for all your help so far. I have had a look at the module and copied
it into my report. If I have a simple =English(99) with a number, it works
just fine. But for some reason when I introduce a field I keep getting an
"error". I have =COUNT(*) in the report footer, and when I put
=English([Count(*)]) it won't work.

Can you help, please !!!!!!

The function was named English() and it accepted a vaue of type Currency.
So if your field is named Amount, you would put this in the Control Source
of the text box on your report:
=English([Amount])

Actually that could error if the field was null, so it would be better to
use
=English(Nz([Amount],0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the link, I have had a look at it and copied it into the
module section of the database. But this is a level above what I have
done in the past (so far I have been strictly a macro person !!!). Now I
have it in the database how do I link it to the text box concerned to
convert the number to words ?

 

[John Spencer]

Try
=English(Count(*))

Note the removal of the square brackets.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Thanks for all your help so far. I have had a look at the module and copied
it into my report. If I have a simple =English(99) with a number, it works
just fine. But for some reason when I introduce a field I keep getting an
"error". I have =COUNT(*) in the report footer, and when I put
=English([Count(*)]) it won't work.

Can you help, please !!!!!!

The function was named English() and it accepted a vaue of type Currency.
So if your field is named Amount, you would put this in the Control Source
of the text box on your report:
=English([Amount])

Actually that could error if the field was null, so it would be better to
use
=English(Nz([Amount],0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the link, I have had a look at it and copied it into the
module section of the database. But this is a level above what I have
done in the past (so far I have been strictly a macro person !!!). Now I
have it in the database how do I link it to the text box concerned to
convert the number to words ?

See:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

Since you clearly understand English as well, it should be easy enough
to change the words in that funtion into Dutch, e.g. substitute the
correct word instead of "hundred".

I have a report that gives a value in the report footer. The value needs
to be in euros, numbers and words. I can calculate the numbers okay, but
as far as I am aware there is no function to convert numbers into words
in Dutch. Thus, I need to have a fill-in field for the value in words,
with the prompt including the value in numbers !

Is this possible ????

I will be eternally grateful for any answers ... Rod

 

[Ro477]

No, removing the square brackets does help I still get #error !!!

Try
=English(Count(*))

Note the removal of the square brackets.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Thanks for all your help so far. I have had a look at the module and
copied it into my report. If I have a simple =English(99) with a number,
it works just fine. But for some reason when I introduce a field I keep
getting an "error". I have =COUNT(*) in the report footer, and when I put
=English([Count(*)]) it won't work.

Can you help, please !!!!!!

The function was named English() and it accepted a vaue of type
Currency. So if your field is named Amount, you would put this in the
Control Source of the text box on your report:
=English([Amount])

Actually that could error if the field was null, so it would be better
to use
=English(Nz([Amount],0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the link, I have had a look at it and copied it into the
module section of the database. But this is a level above what I have
done in the past (so far I have been strictly a macro person !!!). Now
I have it in the database how do I link it to the text box concerned to
convert the number to words ?

See:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

Since you clearly understand English as well, it should be easy enough
to change the words in that funtion into Dutch, e.g. substitute the
correct word instead of "hundred".

I have a report that gives a value in the report footer. The value
needs to be in euros, numbers and words. I can calculate the numbers
okay, but as far as I am aware there is no function to convert
numbers into words in Dutch. Thus, I need to have a fill-in field for
the value in words, with the prompt including the value in numbers !

Is this possible ????

I will be eternally grateful for any answers ... Rod

 

[Ro477]

I notice also, that when I view the report it asks me for an input for
"English" which suggests (I think) that the module English isn't right ! I
just copied the module from Allen's link below and pasted it into a new
module ... that should have worked shouldn't it ??? Or, do i need to do
something extra to activate the module ?

Try
=English(Count(*))

Note the removal of the square brackets.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Thanks for all your help so far. I have had a look at the module and
copied it into my report. If I have a simple =English(99) with a number,
it works just fine. But for some reason when I introduce a field I keep
getting an "error". I have =COUNT(*) in the report footer, and when I put
=English([Count(*)]) it won't work.

Can you help, please !!!!!!

The function was named English() and it accepted a vaue of type
Currency. So if your field is named Amount, you would put this in the
Control Source of the text box on your report:
=English([Amount])

Actually that could error if the field was null, so it would be better
to use
=English(Nz([Amount],0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the link, I have had a look at it and copied it into the
module section of the database. But this is a level above what I have
done in the past (so far I have been strictly a macro person !!!). Now
I have it in the database how do I link it to the text box concerned to
convert the number to words ?

See:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

Since you clearly understand English as well, it should be easy enough
to change the words in that funtion into Dutch, e.g. substitute the
correct word instead of "hundred".

I have a report that gives a value in the report footer. The value
needs to be in euros, numbers and words. I can calculate the numbers
okay, but as far as I am aware there is no function to convert
numbers into words in Dutch. Thus, I need to have a fill-in field for
the value in words, with the prompt including the value in numbers !

Is this possible ????

I will be eternally grateful for any answers ... Rod

 

[John Spencer]

You didn't name the module "English", did you? If so, that causes a
problem.

I also assume that the control is not named "English".

What happens in the VBA immediate window if you type
?English(500)

Does that print "Five Hundred" into the immediate window?

I can't see a reason that this would fail with a reference to a
control/field but would work with a literal value. I can see problems if
you were trying to pass the function a non-number value such as null or a
string.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I notice also, that when I view the report it asks me for an input for
"English" which suggests (I think) that the module English isn't right ! I
just copied the module from Allen's link below and pasted it into a new
module ... that should have worked shouldn't it ??? Or, do i need to do
something extra to activate the module ?

Try
=English(Count(*))

Note the removal of the square brackets.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Thanks for all your help so far. I have had a look at the module and
copied it into my report. If I have a simple =English(99) with a number,
it works just fine. But for some reason when I introduce a field I keep
getting an "error". I have =COUNT(*) in the report footer, and when I
put =English([Count(*)]) it won't work.

Can you help, please !!!!!!

The function was named English() and it accepted a vaue of type
Currency. So if your field is named Amount, you would put this in the
Control Source of the text box on your report:
=English([Amount])

Actually that could error if the field was null, so it would be better
to use
=English(Nz([Amount],0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the link, I have had a look at it and copied it into the
module section of the database. But this is a level above what I have
done in the past (so far I have been strictly a macro person !!!). Now
I have it in the database how do I link it to the text box concerned
to convert the number to words ?

See:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

Since you clearly understand English as well, it should be easy
enough to change the words in that funtion into Dutch, e.g.
substitute the correct word instead of "hundred".

I have a report that gives a value in the report footer. The value
needs to be in euros, numbers and words. I can calculate the numbers
okay, but as far as I am aware there is no function to convert
numbers into words in Dutch. Thus, I need to have a fill-in field
for the value in words, with the prompt including the value in
numbers !

Is this possible ????

I will be eternally grateful for any answers ... Rod

 

[Ro477]

Dear John

thanks for your help. Yes, I named the module English and when I changed it
to a different name ... Englishtext ... the function English works fine.
It works with a number, ie English(500) and now also with Count, ie
=English(Count(*)). I can't get it to work properly with $7.50, it keeps
wanting to do seven and 50/100, but I am sure I can figure it out from the
vba code.

thanks again ... Roger

You didn't name the module "English", did you? If so, that causes a
problem.

I also assume that the control is not named "English".

What happens in the VBA immediate window if you type
?English(500)

Does that print "Five Hundred" into the immediate window?

I can't see a reason that this would fail with a reference to a
control/field but would work with a literal value. I can see problems if
you were trying to pass the function a non-number value such as null or a
string.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

I notice also, that when I view the report it asks me for an input for
"English" which suggests (I think) that the module English isn't right ! I
just copied the module from Allen's link below and pasted it into a new
module ... that should have worked shouldn't it ??? Or, do i need to do
something extra to activate the module ?

Try
=English(Count(*))

Note the removal of the square brackets.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


Ro477 wrote:
Thanks for all your help so far. I have had a look at the module and
copied it into my report. If I have a simple =English(99) with a
number, it works just fine. But for some reason when I introduce a
field I keep getting an "error". I have =COUNT(*) in the report footer,
and when I put =English([Count(*)]) it won't work.

Can you help, please !!!!!!

The function was named English() and it accepted a vaue of type
Currency. So if your field is named Amount, you would put this in the
Control Source of the text box on your report:
=English([Amount])

Actually that could error if the field was null, so it would be better
to use
=English(Nz([Amount],0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the link, I have had a look at it and copied it into the
module section of the database. But this is a level above what I have
done in the past (so far I have been strictly a macro person !!!).
Now I have it in the database how do I link it to the text box
concerned to convert the number to words ?

See:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

Since you clearly understand English as well, it should be easy
enough to change the words in that funtion into Dutch, e.g.
substitute the correct word instead of "hundred".

I have a report that gives a value in the report footer. The value
needs to be in euros, numbers and words. I can calculate the
numbers okay, but as far as I am aware there is no function to
convert numbers into words in Dutch. Thus, I need to have a fill-in
field for the value in words, with the prompt including the value
in numbers !

Is this possible ????

I will be eternally grateful for any answers ... Rod